{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["System Calculation","SC_Loop 1","SC_Loop 2","External power supply","Data","Translations"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"System Calculation","index":0,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,0,39,11],[9,7,9,8],[11,7,12,9],[25,0,27,0],[9,0,9,2],[13,0,13,2]]}
[]
[]
[]
[]
[null,null,null,null,{"$f":"VLOOKUP(\"Pulsar botón para reiniciar todos los valores e iniciar un nuevo proyecto\", Translations!$A$2:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Press the button to reset all the values and start a new project"}]
[]
["SYSTEM CALCULATOR DETNOV CAD-151",null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Idioma\", Translations!$A$2:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Language"},"English",null,"SC 688 m 2025 b"]
[]
[]
[{"$f":"VLOOKUP(\"Tiempo respaldo baterías\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Battery backup time"},null,null,null,null,null,null,{"$f":"VLOOKUP(\"Máximo nº sirenas en alarma simultánea\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Maximum sounders in alarm at the same time"}]
[{"$f":"VLOOKUP(\"Tiempo en reposo\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Standby time"},null,"h",{"$f":"VLOOKUP(\"Seleccionar tiempo en reposo\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Select standby time"},null,null,null,{"$f":"VLOOKUP(\"Sirenas\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Sounders"}]
[{"$f":"VLOOKUP(\"Tiempo en alarma\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Alarm time"},null,"min",{"$f":"VLOOKUP(\"Seleccionar tiempo en alarma\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Select alarm time"},null,null,null,{"$f":"VLOOKUP(\"Cumplimentar el campo para el máximo % de sirenas en alarma al mismo tiempo (campo amarillo)\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Fill the field for the maximum % of sounders in alarm at the same time"}]
[null,{"$f":"IF(OR(B11=48,B11=24),VLOOKUP(\"Nota: los valores seleccionados no cumplen EN 54\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE),\" \")","v":" "}]
[{"$f":"VLOOKUP(\"Parámetros del sistema y baterías\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Battery and system parameters"},null,null,{"$f":"IF(A15<>\" \",VLOOKUP(A15,Data!B4:F17,5,0),0)","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(A15<>\" \",VLOOKUP(A15,Data!B4:D17,2,0),0)","v":{"$error":"#N/A"}},{"$f":"IF(A15<>\" \",VLOOKUP(A15,Data!B4:D17,3,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(\"Seleccionar central de la lista\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Select control panel from the list"}]
[null,{"$f":"IFERROR(VLOOKUP(A16,Data!H4:J7,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A16,Data!H4:J7,3,0),0)","v":0},{"$f":"VLOOKUP(\"Seleccionar batería de la lista\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Select battery from the list"}]
[null,{"$f":"VLOOKUP(\"I_Reposo (A)\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"I_Standby (A)"},{"$f":"VLOOKUP(\"I_Alarma (A)\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"I_Alarm (A)"}]
[{"$f":"VLOOKUP(\"Salida auxiliar 24 V central\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Panel auxilliary 24 V output"},null,null,null,{"$f":"IF(C18>0.5,\"Aviso: Corriente máxima 500mA excedida. Necesaria fuente externa 24V\",\"\")","v":""}]
[{"$f":"VLOOKUP(\"Salida sirenas 1\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Sounder output 1"},null,null,null,{"$f":"IF(C19>0.5,\"Aviso: Corriente máxima 500mA excedida. Necesaria fuente externa 24V\",\"\")","v":""}]
[{"$f":"VLOOKUP(\"Salida sirenas 2\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Sounder output 2"},null,null,null,{"$f":"IF(C20>0.5,\"Aviso: Corriente máxima 500mA excedida. Necesaria fuente externa 24V\",\"\")","v":""}]
[{"$f":"VLOOKUP(\"I_Total_Reposo\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"I_Total_Standby"},{"$f":"B15+B18+B19+B20+B35+H37","v":{"$error":"#N/A"}},"A"]
[{"$f":"VLOOKUP(\"I_Total_Alarma\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"I_Total_Alarm"},{"$f":"C35+C15+C18+C19+C20+H37","v":{"$error":"#N/A"}},"A",null,{"$f":"VLOOKUP(\"Batería mínima necesaria\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Minimum battery required"},null,null,{"$f":"VLOOKUP(\"Tiempo baterías*\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Battery time*"},null,null," "]
[{"$f":"VLOOKUP(\"Factor de degradación\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Derating factor"},0.25,{"$f":"1+B23","v":1.25},{"$f":"ROUNDUP(E23,1)","v":{"$error":"#N/A"}},{"$f":"((B21*B11)+(B22*(B12/60)))*C23","v":{"$error":"#N/A"}},null,null,"2 x 7,2 Ah","2 x 12 Ah","2 x 18 Ah","2 x 24 Ah"]
["1,25 Cmin",{"$f":"IF(A15<>\" \",VLOOKUP(A15,Data!B4:E17,4,0),0)","v":{"$error":"#N/A"}},null,{"$f":"MATCH(D23,Data!K8:K9,-1)","v":{"$error":"#N/A"}},null,null,null,{"$f":"((7.5/C23)-($B$22*($B$12/60)))/$B$21","v":{"$error":"#N/A"}},{"$f":"((12/C23)-($B$22*($B$12/60)))/$B$21","v":{"$error":"#N/A"}},{"$f":"((18/C23)-($B$22*($B$12/60)))/$B$21","v":{"$error":"#N/A"}},{"$f":"((24/C23)-($B$22*($B$12/60)))/$B$21","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"*Tiempo baterías = Tiempo reposo + Tiempo en alarma\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"*Battery time = Standby time + Alarm mode time"}]
[{"$f":"VLOOKUP(\"Batería seleccionada para la autonomía\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Battery selected for backup time"},{"$f":"IF(E23<=$C$16,\"OK\",IF(E23>$D$14,VLOOKUP(\"No suficiente\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE),\"Necesita batería:\"))","v":{"$error":"#N/A"}},{"$f":"IF(B26<>\"OK\",INDEX(Data!L8:L9,'System Calculation'!D24),\" \")","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(E23>$D$14,VLOOKUP(\"Necesita fuente de alimentación externa:\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE))","v":{"$error":"#N/A"}},null,null,{"$f":"IF($B$27<>FALSE,Data!K36,\" \")","v":{"$error":"#N/A"}},null,null,{"$f":"IF(ISTEXT(B27)=TRUE,VLOOKUP(\"Revisar pestaña Conexión fuente externa\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE))","v":false}]
[null,{"$f":"IF(E23>$D$14,VLOOKUP(\"Con baterías adicionales mínimas de:\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE))","v":{"$error":"#N/A"}},null,null,{"$f":"IF($B$27<>FALSE,Data!I36,\" \")","v":{"$error":"#N/A"}}]
[{"$f":"VLOOKUP(\"Consumo sistema\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"System consumption"},{"$f":"IF(B22<=B24,\"OK\",VLOOKUP(\"El sistema excede el consumo máximo permitido\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE))","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,{"$f":"VLOOKUP(\"Cumplimentar el campo PCS si la central tiene tarjetas auxiliares (campo amarillo)\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Fill the PCS field if the panel includes extension cards"}]
[{"$f":"VLOOKUP(\"Lazo\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Loop"},{"$f":"VLOOKUP(\"I_Reposo (A)\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"I_Standby (A)"},{"$f":"VLOOKUP(\"I_Alarma (A)\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"I_Alarm (A)"},null,{"$f":"VLOOKUP(\"Tarjetas auxiliares\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Extension cards"},{"$f":"VLOOKUP(\"PCS\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"PCS"},"I_Standby (A)",{"$f":"VLOOKUP(\"I_Reposo (A)\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"I_Standby (A)"}]
[{"$f":"VLOOKUP(\"Lazo 1\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Loop 1"},{"$f":"'SC_Loop 1'!$B$82*33/(24*0.9)","v":0},{"$f":"'SC_Loop 1'!$B$85*33/(24*0.9)","v":0},null,"TMB-251-CAN",null,0.05,{"$f":"F33*G33","v":0}]
[{"$f":"VLOOKUP(\"Lazo 2\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Loop 2"},{"$f":"'SC_Loop 2'!$B$82*33/(24*0.9)","v":0},{"$f":"'SC_Loop 2'!$B$85*33/(24*0.9)","v":0},null,"TED-151-1PE-CAN",null,0.05,{"$f":"F34*G34","v":0}]
[{"$f":"VLOOKUP(\"Total\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Total"},{"$f":"SUM(B33:B34)","v":0},{"$f":"SUM(C33:C34)","v":0},null,"TED-151-CL-CAN",null,0.05,{"$f":"F35*G35","v":0}]
[null,null,null,null,"FAD-AUXBAT",null,3.1E-2,{"$f":"F36*G36","v":0}]
[null,null,null,null,{"$f":"VLOOKUP(\"Total\", Translations!$A$4:$E$209, MATCH($J$7, Translations!$A$1:$E$1, 0), FALSE)","v":"Total"},{"$f":"SUM(F33:F33)","v":0},null,{"$f":"SUM(H33:H36)","v":0}]
[null,null,null,null,null,{"$f":"IF(F37>1,\"Aviso: máximo 1 tarjeta de comunicación en la central\",\"\")","v":""}]
[]
[{"$f":"VLOOKUP(\"Esta herramienta se puede utilizar como ayuda de diseño para Detnov Security S.L.\",Translations!$A$4:$E$209,MATCH($J$7,Translations!$A$1:$E$1,0),FALSE)","v":"This tool may be used as a design help for Detnov Security S.L. We reserve the right not to be responsible for its accuracy, completeness or quality of the information provided, including any kind of information which could be incomplete or incorrect."}]

{"sheet":"SC_Loop 1","index":1,"n_rows":114,"n_cols":31,"rows_kept":114,"cut":false,"hidden":false,"merged":[[113,0,113,13],[9,11,9,12],[10,11,10,12],[8,11,8,13],[9,8,10,10],[11,3,12,12]]}
[]
[]
[]
[]
[{"$f":"'System Calculation'!A7","v":"SYSTEM CALCULATOR DETNOV CAD-151"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'System Calculation'!L7","v":"SC 688 m 2025 b"}]
[]
[{"$f":"VLOOKUP(\"Cumplimentar Sección de cable en mm2 y Longitud de lazo en metros (campo amarillo)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Fill Cable cross section in mm2 and Loop length in meters"}]
[{"$f":"VLOOKUP(\"Seleccionar el factor de distribución en el lazo y topología de clase\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Select the distribution factor in the loop and the topology"}]
[{"$f":"VLOOKUP(\"Lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Loop"},null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Comprobación sistema\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"System check"},null,null,null,{"$f":"VLOOKUP(\"Trama comunicaciones\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Communication frame"},null,26]
[{"$f":"VLOOKUP(\"Sección de cable\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Cable cross section"},null,{"$f":"IFERROR(VLOOKUP($B$10,Data!$H$17:$I$23,2,FALSE),\"ERROR\")","v":"ERROR"},null,null,null,null,null,{"$f":"IF(B11>3500,VLOOKUP(\"Error: La longitud máxima de lazo es 3500 m\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\"\")","v":""},null,null,{"$f":"VLOOKUP(\"Corriente\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Consumption"},null,{"$f":"IFERROR(IF($B$85>0.75,VLOOKUP(\"FALLO\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),IF($B$107>=$B$85,\"OK\",\"FALLO\")),VLOOKUP(\"ERROR\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE))","v":"OK"},null,{"$f":"IFERROR(IF($B$85>0.75,VLOOKUP(\"Error: La corriente de lazo es mayor que la corriente máxima permitida\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),IF($B$107<$B$85,VLOOKUP(\"Error: La corriente de lazo es mayor que la corriente máxima permitida\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\"\")),VLOOKUP(\"ERROR: Los datos no son correctos\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE))","v":""}]
[{"$f":"VLOOKUP(\"Longitud de lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Loop length"},null,{"$f":"VLOOKUP(\"metros\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"meters"},null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Direcciones\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Directions"},null,{"$f":"IF($N$77<=250,VLOOKUP(\"OK\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),VLOOKUP(\"FALLO\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE))","v":"OK"},null,{"$f":"IF($N$77>250,VLOOKUP(\"Error: El lazo no admite más de 250 direcciones\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Información\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Information"}]
[{"$f":"VLOOKUP(\"Distancia de S al primer dispositivo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Distance from S to first device"},null,{"$f":"VLOOKUP(\"metros\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"meters"},{"$f":"IF(B12+B13>B11,VLOOKUP(\"La suma de distancias desde la central a los dipositivos no puede ser mayor a la longitud de lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(P13<>\"\",VLOOKUP(\"Indicaciones\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\"\"),VLOOKUP(\"Indicaciones\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Esta es la distancia de la salida del lazo hasta el primer dispositivo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"This is the distance from the S of the loop to the first device"}]
[{"$f":"VLOOKUP(\"Distancia de R al último dispositivo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Distance from R to last device"},null,{"$f":"VLOOKUP(\"metros\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"meters"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($N$77>250,VLOOKUP(\"Reduzca el número de direcciones utilizadas\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),IF($B$85>0.75,VLOOKUP(\"Trate de reducir el consumo ajustando la cantidad de dispositivos\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),IF($B$107<$B$85,VLOOKUP(\"Trate de modificar los parámetros de cable y lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\"\"))),VLOOKUP(\"Revise o rellene los datos de configuración de lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Esta es la distancia del último dispositivo al retorno del lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"This is the distance from the last device to the R of the loop"}]
[{"$f":"VLOOKUP(\"Topología de lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Loop topology"},null,{"$f":"IFERROR(VLOOKUP(B14,Data!$D$45:$E$46,2,FALSE),\"ERROR\")","v":"ERROR"},null,{"$f":"IF($B$14=Data!D46,VLOOKUP(\"Lazo abierto. Toda la corriente en el mismo extremo del cable (peor caso)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),VLOOKUP(\"Lazo cerrado. Se divide la corriente por los dos extremos (mejor caso)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE))","v":"Closed loop. The current is divided on both ends (best case)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"La topología de lazo hace referencia\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Loop topology takes into account whether the loop is closed in Class A, or the loop is in degraded mode due to an open loop fault "}]
[{"$f":"VLOOKUP(\"Factor de distribución\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Distribution factor"},1,{"$f":"VLOOKUP(B15,Data!$A$21:$B$49,2,FALSE)","v":0.56999999999999995},null,{"$f":"IF($B$15=1,VLOOKUP(\"Distribuidos equitativamente (mejor caso)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),IF($B$15=0,VLOOKUP(\"Todos en el mismo extremo del cable (peor caso)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),VLOOKUP(\"Caso intermedio\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)))","v":"Equally distributed (best case)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"El factor de distribución hace referencia\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Distribution factor is an estimation of how equitative are the devices distributed along the loop, being 100% perfectly distributed"}]
[]
[null,null,{"$f":"VLOOKUP(\"Cumplimentar el campo PCS para la configuración deseada (campo amarillo)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Fill the PCS field for the desired configuration"}]
[{"$f":"VLOOKUP(\"Dispositivos lazo 1\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Loop 1 devices"}]
[{"$f":"VLOOKUP(\"REF.\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"REF."},{"$f":"VLOOKUP(\"Descripción\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Description"},{"$f":"VLOOKUP(\"PCS\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"PCS"},"I_Standby (A)",{"$f":"VLOOKUP(\"I_Reposo (A)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"I_Standby (A)"},"PCS_alarm","I_Alarm (A)","I_Alarm_aux (A)",{"$f":"VLOOKUP(\"I_Alarma (A)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"I_Alarm (A)"},{"$f":"VLOOKUP(\"I_Sirenas (A)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"I_Sounders (A)"},{"$f":"VLOOKUP(\"DET\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"DET"},{"$f":"VLOOKUP(\"MOD\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MOD"},{"$f":"VLOOKUP(\"SIR\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"SND"},{"$f":"VLOOKUP(\"DIR\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"DIR"}]
["DOD-220A",{"$f":"VLOOKUP(\"Detector óptico analógico\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable optical smoke detector"},null,{"$f":"127.2*10^-6","v":1.272E-4},{"$f":"C20*D20","v":0},{"$f":"IFERROR(INDEX($AE$22:$AE$37,MATCH(H20,$AB$22:$AB$37,0)),0)","v":0},{"$f":"3.61*10^-3","v":3.6099999999999999E-3},{"$f":"IF(C20>0,G20+ROW(G20)/100000000000,0)","v":0},{"$f":"IF(F20>0,F20*G20+(C20-F20)*D20,C20*D20)","v":0},null,{"$f":"IF(C20<>0,C20,\" \")","v":" "},null,null,{"$f":"IF(K20<>0,K20,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,"* Si no quiero que algún dispositivo esté aquí, poner a 0 su valor en columna H"]
["DOD-220A-I",{"$f":"VLOOKUP(\"Detector óptico analógico con aislador incorporado\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable optical smoke detector with built-in isolator"},null,{"$f":"195.8*10^-6","v":1.9580000000000002E-4},{"$f":"C21*D21","v":0},0,{"$f":"3.74*10^-3","v":3.7400000000000003E-3},{"$f":"IF(C21>0,G21+ROW(G21)/100000000000,0)","v":0},{"$f":"IF(F21>0,F21*G21+(C21-F21)*D21,C21*D21)","v":0},null," ",null,null,{"$f":"IF(K21<>0,K21,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,"Orden","Valor","PCS","Cuantos quedan para 16","PCS alarma"]
["DOTD-230A",{"$f":"VLOOKUP(\"Detector óptico-térmico\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable optical & heat detector"},null,{"$f":"141.6*10^-6","v":1.416E-4},{"$f":"C22*D22","v":0},0,{"$f":"3.6*10^-3","v":3.6000000000000003E-3},0,0,null," ",null,null,{"$f":"IF(K22<>0,K22,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"LARGE($H$20:$H$53,AA22)","v":0},{"$f":"INDEX(C:C,MATCH(AB22,H:H,0))","v":0},{"$f":"IF(16-AC22>0,16-AC22,0)","v":16},{"$f":"IF(AD22>0,AC22,16)","v":0}]
["DOTD-230A-I",{"$f":"VLOOKUP(\"Detector óptico-térmico con aislador incorporado\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable optical & heat detector with built-in isolator"},null,{"$f":"212.4*10^-6","v":2.1239999999999999E-4},0,0,{"$f":"3.74*10^-3","v":3.7400000000000003E-3},0,0,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,2,0,0,{"$f":"IF(AD22-AC23>0,AD22-AC23,0)","v":16},{"$f":"IF(AD23>0,AC23,AD22)","v":0}]
["DTD-210A",{"$f":"VLOOKUP(\"Detector térmico analógico\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable heat detector"},null,{"$f":"122.2*10^-6","v":1.2219999999999999E-4},0,0,{"$f":"3.64*10^-3","v":3.64E-3},0,0,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,3,0,0,{"$f":"IF(AD23-AC24>0,AD23-AC24,0)","v":16},{"$f":"IF(AD24>0,AC24,AD23)","v":0}]
["DTD-210A-I",{"$f":"VLOOKUP(\"Detector térmico analógico con aislador incorporado\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable heat detector with built-in isolator"},null,{"$f":"192.4*10^-6","v":1.9239999999999999E-4},0,0,{"$f":"3.76*10^-3","v":3.7599999999999999E-3},0,0,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,4,0,0,16,0]
["DTD-215A",{"$f":"VLOOKUP(\"Detector térmico de alta temperatura analógico\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable high temperature detector"},null,{"$f":"133.7*10^-6","v":1.3369999999999997E-4},0,0,{"$f":"3.78*10^-3","v":3.7799999999999999E-3},0,0,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,5,0,0,16,0]
["DTD-215A-I",{"$f":"VLOOKUP(\"Detector térmico de alta temperatura analógico con aislador incorporado\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable high temperature detector with built-in isolator"},null,{"$f":"203.5*10^-6","v":2.0349999999999999E-4},0,0,{"$f":"3.77*10^-3","v":3.7699999999999999E-3},0,0,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,6,0,0,16,0]
["DGD-600",{"$f":"VLOOKUP(\"Detector autónomo de gas natural (24V)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Standalone natural gas detector (24V)"},null,{"$f":"2180*10^-6","v":2.1800000000000001E-3},0,0,{"$f":"2.22*10^-3","v":2.2200000000000002E-3},0,0,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,7,0,0,16,0]
["DGD-600-AC",{"$f":"VLOOKUP(\"Detector autónomo de gas natural (230V)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Standalone natural gas detector (230V)"},null,{"$f":"2600*10^-6","v":2.5999999999999999E-3},0,0,{"$f":"3.16*10^-3","v":3.16E-3},0,0,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,8,0,0,16,0]
["DGD-620",{"$f":"VLOOKUP(\"Detector autónomo de GLP (24V)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Standalone LPG detector (24V)"},null,{"$f":"2180*10^-6","v":2.1800000000000001E-3},0,0,{"$f":"2.22*10^-3","v":2.2200000000000002E-3},0,0,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,9,0,0,16,0]
["DGD-620-AC",{"$f":"VLOOKUP(\"Detector autónomo de GLP (230V)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Standalone LPG detector (230V)"},null,{"$f":"2600*10^-6","v":2.5999999999999999E-3},0,0,{"$f":"3.16*10^-3","v":3.16E-3},0,0,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,10,0,0,16,0]
["DBD-70A",{"$f":"VLOOKUP(\"Detector lineal de humos analógico\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable beam smoke detector"},null,4.0000000000000001E-3,{"$f":"C32*D32","v":0},{"$f":"C32","v":0},4.0000000000000001E-3,{"$f":"0","v":0},{"$f":"IF(F32>0,F32*G32+(C32-F32)*D32,C32*D32)","v":0},null," ",null,null," ",null,{"$f":"IF(C32>20,VLOOKUP(\"Info: El máximo número de barreras es 20\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),IF(C32>0,VLOOKUP(\"Info: Alinear barreras de una en una\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \"))","v":" "},null,null,null,null,null,null,null,null,null,null,11,0,0,16,0]
["MAD-401 & MAD-401-I",{"$f":"VLOOKUP(\"Módulo analógico de 1 entrada (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 1 input (with/without isolator)"},null,{"$f":"216.8*10^-6","v":2.1680000000000001E-4},0,{"$f":"IFERROR(INDEX($AE$22:$AE$37,MATCH(H33,$AB$22:$AB$37,0)),0)","v":0},{"$f":"3.06*10^-3","v":3.0600000000000002E-3},0,0,null,null,{"$f":"IF(C33<>0,C33,\" \")","v":" "},null,{"$f":"IF(L33<>0,L33,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,12,0,0,16,0]
["MAD-402 & MAD-402-I",{"$f":"VLOOKUP(\"Módulo analógico de 2 entradas (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 2 inputs (with/without isolator)"},null,{"$f":"217.4*10^-6","v":2.174E-4},{"$f":"C34*D34","v":0},0,{"$f":"5.95*10^-3","v":5.9500000000000004E-3},0,0,null,null,{"$f":"IF(C34<>0,C34,0)","v":0},null,{"$f":"IF(L34<>0,L34*2,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,13,0,0,16,0]
["MAD-405-I",{"$f":"VLOOKUP(\"Módulo analógico de 5 entradas con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 5 inputs with isolator"},null,{"$f":"278.6*10^-6","v":2.786E-4},0,0,{"$f":"3.15*10^-3","v":3.15E-3},0,0,null,null,{"$f":"IF(C35<>0,C35,0)","v":0},null,{"$f":"IF(L35<>0,L35*5,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,14,0,0,16,0]
["MAD-409-I",{"$f":"VLOOKUP(\"Módulo analógico de 10 entradas con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 10 inputs with isolator"},null,{"$f":"367.7*10^-6","v":3.6769999999999999E-4},0,0,{"$f":"3.3*10^-3","v":3.3E-3},0,0,null,null,{"$f":"IF(C36<>0,C36,0)","v":0},null,{"$f":"IF(L36<>0,L36*10,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,16,0]
["MAD-411 & MAD-411-I",{"$f":"VLOOKUP(\"Módulo analógico de 1 salida (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 1 output (with/without isolator)"},null,{"$f":"191.6*10^-6","v":1.916E-4},0,0,{"$f":"3.06*10^-3","v":3.0600000000000002E-3},0,0,null,null,{"$f":"IF(C37<>0,C37,\" \")","v":" "},null,{"$f":"IF(L37<>0,L37,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,16,0,0,16,0]
["MAD-412 & MAD-412-I",{"$f":"VLOOKUP(\"Módulo analógico de 2 salidas (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 2 outputs (with/without isolator)"},null,{"$f":"191*10^-6","v":1.9099999999999998E-4},0,0,{"$f":"5.84*10^-3","v":5.8399999999999997E-3},0,0,null,null,{"$f":"IF(C38<>0,C38,0)","v":0},null,{"$f":"IF(L38<>0,L38*2,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(AC22:AC37)","v":0},null,{"$f":"SUM(AE22:AE37)","v":0}]
["MAD-415-I",{"$f":"VLOOKUP(\"Módulo analógico de 5 salidas con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 5 outputs with isolator"},null,{"$f":"188.8*10^-6","v":1.8880000000000001E-4},0,0,{"$f":"3.95*10^-3","v":3.9500000000000004E-3},0,0,null,null,0,null,{"$f":"IF(L39<>0,L39*5,\" \")","v":" "},null,{"$f":"IF(AND(C39>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. La central puede dar 24Vaux, si la corriente máxima 500mA no es excedida.\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
["MAD-419-I",{"$f":"VLOOKUP(\"Módulo analógico de 10 salidas con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 10 outputs with isolator"},null,{"$f":"189.2*10^-6","v":1.8919999999999999E-4},0,0,{"$f":"4.84*10^-3","v":4.8399999999999997E-3},0,0,null,null,0,null,{"$f":"IF(L40<>0,L40*10,\" \")","v":" "},null,{"$f":"IF(AND(C40>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. La central puede dar 24Vaux, si la corriente máxima 500mA no es excedida.\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
["MAD-421 & MAD-421-I",{"$f":"VLOOKUP(\"Módulo analógico de 1 entrada/1 salida (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 1 input/1 output (with/without isolator)"},null,{"$f":"210.1*10^-6","v":2.1009999999999998E-4},0,0,{"$f":"5.92*10^-3","v":5.9199999999999999E-3},0,0,null,null,0,null,{"$f":"IF(L41<>0,L41*2,\" \")","v":" "}]
["MAD-422 & MAD-422-I",{"$f":"VLOOKUP(\"Módulo analógico de 2 entradas/2 salidas (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 2 inputs/2 outputs (with/without isolator)"},null,{"$f":"234*10^-6","v":2.34E-4},0,0,{"$f":"5.91*10^-3","v":5.9100000000000003E-3},0,0,null,null,0,null,{"$f":"IF(L42<>0,L42*4,\" \")","v":" "}]
["MAD-425-I",{"$f":"VLOOKUP(\"Módulo analógico de 5 entradas/5 salidas con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 5 inputs/5 outputs with isolator"},null,{"$f":"284*10^-6","v":2.8399999999999996E-4},0,0,{"$f":"4.08*10^-3","v":4.0800000000000003E-3},0,0,null,null,0,null,{"$f":"IF(L43<>0,L43*10,\" \")","v":" "},null,{"$f":"IF(AND(C43>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. La central puede dar 24Vaux, si la corriente máxima 500mA no es excedida.\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
["MAD-429-I",{"$f":"VLOOKUP(\"Módulo analógico de 10 entradas/10 salidas con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 10 inputs/10 outputs with isolator"},null,{"$f":"376.6*10^-6","v":3.7659999999999999E-4},0,0,{"$f":"5*10^-3","v":5.0000000000000001E-3},0,0,null,null,0,null,{"$f":"IF(L44<>0,L44*20,\" \")","v":" "},null,{"$f":"IF(AND(C44>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. La central puede dar 24Vaux, si la corriente máxima 500mA no es excedida.\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
["MAD-431 & MAD-431-I",{"$f":"VLOOKUP(\"Módulo analógico de 1 salida 24V (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 1 24V output (with/without isolator)"},null,{"$f":"215*10^-6","v":2.1499999999999999E-4},0,0,{"$f":"3.61*10^-3","v":3.6099999999999999E-3},0,0,null,null,{"$f":"IF(C45<>0,C45,0)","v":0},null,{"$f":"IF(L45<>0,L45,\" \")","v":" "},null,{"$f":"IF(AND(C45>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. La central puede dar 24Vaux, si la corriente máxima 500mA no es excedida.\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
["MAD-432 & MAD-432-I",{"$f":"VLOOKUP(\"Módulo analógico de 2 salidas 24V (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 2 24V outputs (with/without isolator)"},null,{"$f":"203.3*10^-6","v":2.0330000000000001E-4},0,0,{"$f":"6.8*10^-3","v":6.7999999999999996E-3},0,0,null,null,0,null,{"$f":"IF(L46<>0,L46*2,\" \")","v":" "},null,{"$f":"IF(AND(C46>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. La central puede dar 24Vaux, si la corriente máxima 500mA no es excedida.\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
["MAD-441 & MAD-441-I",{"$f":"VLOOKUP(\"Módulo analógico de 1 zona convencional (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 1 conventional zone (with/without isolator)"},null,{"$f":"187.8*10^-6","v":1.8780000000000001E-4},0,0,{"$f":"3.04*10^-3","v":3.0400000000000002E-3},0,0,null,null,0,null,{"$f":"IF(L47<>0,L47,\" \")","v":" "},null,{"$f":"IF(AND(C47>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. La central puede dar 24Vaux, si la corriente máxima 500mA no es excedida.\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
["MAD-442 & MAD-442-I",{"$f":"VLOOKUP(\"Módulo analógico de 2 zonas convencionales (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 2 conventional zones (with/without isolator)"},null,{"$f":"187.8*10^-6","v":1.8780000000000001E-4},0,0,{"$f":"5.84*10^-3","v":5.8399999999999997E-3},0,0,null,null,0,null,{"$f":"IF(L48<>0,L48*2,\" \")","v":" "},null,{"$f":"IF(AND(C48>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. La central puede dar 24Vaux, si la corriente máxima 500mA no es excedida.\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
["MAD-481",{"$f":"VLOOKUP(\"Módulo analógico de 1 salida 230V\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 1 230V output"},null,1.176E-4,{"$f":"C49*D49","v":0},0,2.8800000000000002E-3,0,0,null,null,0,null,{"$f":"IF(L49<>0,L49,\" \")","v":" "}]
["MAD-490",{"$f":"VLOOKUP(\"Módulo analógico aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module isolator"},null,{"$f":"69.6*10^-6","v":6.9599999999999998E-5},0,0,{"$f":"37.66*10^-3","v":3.7659999999999999E-2},0,0,null,null,0,null,{"$f":"IF(L50<>0,L50,\" \")","v":" "}]
["MAD-450 & MAD-450-I",{"$f":"VLOOKUP(\"Pulsador analógico con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable manual call with isolator"},null,{"$f":"176.6*10^-6","v":1.7659999999999998E-4},0,0,{"$f":"3.03*10^-3","v":3.0299999999999997E-3},0,0,null,null,0,null,{"$f":"IF(C51<>0,C51,\" \")","v":" "}]
["MAD-451-I",{"$f":"VLOOKUP(\"Pulsador analógico con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable manual call with isolator"},null,{"$f":"177.4*10^-6","v":1.774E-4},0,0,{"$f":"3*10^-3","v":3.0000000000000001E-3},0,0,null,null,0,null,{"$f":"IF(C52<>0,C52,\" \")","v":" "}]
["MAD-452 & MAD-452-I",{"$f":"VLOOKUP(\"Pulsador analógico con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable manual call with isolator"},null,3.4099999999999999E-4,0,0,1.81E-3,0,0,null,null,0,null,{"$f":"IF(C53<>0,C53,\" \")","v":" "}]
["MAD-461-I",{"$f":"VLOOKUP(\"Sirena analógica con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable sounder with isolator"},null,{"$f":"176.9*10^-6","v":1.7689999999999999E-4},0,{"$f":"C54*'System Calculation'!$I$11","v":0},{"$f":"8.35*10^-3","v":8.3499999999999998E-3},0,{"$f":"IF(F54>0,F54*G54+(C54-F54)*D54,C54*D54)","v":0},{"$f":"IF(C54*I54=0,\" \",I54)","v":" "},null,null,{"$f":"IF(C54<>0,C54,\" \")","v":" "},{"$f":"IF(M54<>0,M54,\" \")","v":" "}]
["MAD-464-I",{"$f":"VLOOKUP(\"Sirena analógica con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable sounder with isolator"},null,{"$f":"176.5*10^-6","v":1.7649999999999998E-4},{"$f":"C55*D55","v":0},{"$f":"C55*'System Calculation'!$I$11","v":0},{"$f":"12.32*10^-3","v":1.2320000000000001E-2},0,0," ",null,null," ",{"$f":"IF(M55<>0,M55,\" \")","v":" "}]
["MAD-465-I",{"$f":"VLOOKUP(\"Sirena analógica con flash y aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable sounder with beacon and isolator"},null,{"$f":"177.3*10^-6","v":1.773E-4},{"$f":"C56*D56","v":0},{"$f":"C56*'System Calculation'!$I$11","v":0},{"$f":"12.32*10^-3","v":1.2320000000000001E-2},0,0," ",null,null," "," "]
[{"$f":"VLOOKUP(\"MAD-564-I (lazo)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-564-I (loop)"},{"$f":"VLOOKUP(\"Sirena analógica con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable sounder with isolator"},null,{"$f":"1580*10^-6","v":1.58E-3},0,{"$f":"C57*'System Calculation'!$I$11","v":0},{"$f":"21.11*10^-3","v":2.111E-2},0,0," ",null,null," "," "]
[{"$f":"VLOOKUP(\"MAD-564-I (FA externa)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-564-I (external PS)"},{"$f":"VLOOKUP(\"Sirena analógica con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable sounder with isolator"},null,{"$f":"350*10^-6","v":3.5E-4},0,{"$f":"C58*'System Calculation'!$I$11","v":0},{"$f":"0.8*10^-3","v":8.0000000000000004E-4},0,0," ",null,null," "," ",null,{"$f":"IF(AND(C58>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. Certificada EN 54-4\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
[{"$f":"VLOOKUP(\"MAD-565-I (lazo)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-565-I (loop)"},{"$f":"VLOOKUP(\"Sirena analógica con VAD y aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable sounder with VAD and isolator"},null,{"$f":"1580*10^-6","v":1.58E-3},0,{"$f":"C59*'System Calculation'!$I$11","v":0},{"$f":"33.45*10^-3","v":3.3450000000000001E-2},0,0," ",null,null," "," "]
[{"$f":"VLOOKUP(\"MAD-565-I (FA externa)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-565-I (external PS)"},{"$f":"VLOOKUP(\"Sirena analógica con VAD y aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable sounder with VAD and isolator"},null,{"$f":"350*10^-6","v":3.5E-4},0,{"$f":"C60*'System Calculation'!$I$11","v":0},{"$f":"0.8*10^-3","v":8.0000000000000004E-4},0,0," ",null,null," "," ",null,{"$f":"IF(AND(C60>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. Certificada EN 54-4\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
[{"$f":"VLOOKUP(\"MAD-565-I - solo flash (lazo)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-565-I - only flash (loop)"},{"$f":"VLOOKUP(\"VAD analógico con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable VAD with isolator"},null,{"$f":"1580*10^-6","v":1.58E-3},{"$f":"C61*D61","v":0},{"$f":"C61*'System Calculation'!$I$11","v":0},{"$f":"33.45*10^-3","v":3.3450000000000001E-2},0,0," ",null,null," "," "]
[{"$f":"VLOOKUP(\"MAD-565-I - solo flash (FA externa)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-565-I - only flash (external PS)"},{"$f":"VLOOKUP(\"VAD analógico con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable VAD with isolator"},null,{"$f":"350*10^-6","v":3.5E-4},{"$f":"C62*D62","v":0},{"$f":"C62*'System Calculation'!$I$11","v":0},{"$f":"0.8*10^-3","v":8.0000000000000004E-4},0,0," ",null,null," "," ",null,{"$f":"IF(AND(C62>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. Certificada EN 54-4\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
[{"$f":"VLOOKUP(\"MAD-567-I (lazo)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-567-I (loop)"},{"$f":"VLOOKUP(\"Base sirena con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Sounder base with isolator"},null,{"$f":"1170*10^-6","v":1.17E-3},0,{"$f":"C63*'System Calculation'!$I$11","v":0},{"$f":"8.95*10^-3","v":8.9499999999999996E-3},0,0," ",null,null," "," "]
[{"$f":"VLOOKUP(\"MAD-567-I (FA externa)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-567-I (external PS)"},{"$f":"VLOOKUP(\"Base sirena con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Sounder base with isolator"},null,{"$f":"261*10^-6","v":2.61E-4},{"$f":"C64*D64","v":0},{"$f":"C64*'System Calculation'!$I$11","v":0},{"$f":"0.71*10^-3","v":7.1000000000000002E-4},0,0," ",null,null," "," ",null,{"$f":"IF(AND(C64>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. Certificada EN 54-4\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
[{"$f":"VLOOKUP(\"MAD-569-I (lazo)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-569-I (loop)"},{"$f":"VLOOKUP(\"Base sirena y VAD con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Sounder base and VAD with isolator"},null,{"$f":"1170*10^-6","v":1.17E-3},0,{"$f":"C65*'System Calculation'!$I$11","v":0},{"$f":"23.26*10^-3","v":2.3260000000000003E-2},0,0," ",null,null," "," "]
[{"$f":"VLOOKUP(\"MAD-569-I (FA externa)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-569-I (external PS)"},{"$f":"VLOOKUP(\"Base sirena y VAD con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Sounder base and VAD with isolator"},null,{"$f":"258.9*10^-6","v":2.5889999999999995E-4},0,{"$f":"C66*'System Calculation'!$I$11","v":0},{"$f":"0.71*10^-3","v":7.1000000000000002E-4},0,0," ",null,null," "," ",null,{"$f":"IF(AND(C66>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. Certificada EN 54-4\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
[{"$f":"VLOOKUP(\"MAD-569-I - solo flash (lazo)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-569-I - only flash (loop)"},{"$f":"VLOOKUP(\"Base VAD con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"VAD base with isolator"},null,{"$f":"1170*10^-6","v":1.17E-3},{"$f":"C67*D67","v":0},{"$f":"C67*'System Calculation'!$I$11","v":0},{"$f":"23.26*10^-3","v":2.3260000000000003E-2},0,0," ",null,null," "," "]
[{"$f":"VLOOKUP(\"MAD-569-I solo flash (FA externa)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-569-I only flash (external PS)"},{"$f":"VLOOKUP(\"Base VAD con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"VAD base with isolator"},null,{"$f":"258.9*10^-6","v":2.5889999999999995E-4},0,{"$f":"C68*'System Calculation'!$I$11","v":0},{"$f":"0.71*10^-3","v":7.1000000000000002E-4},0,0," ",null,null," "," ",null,{"$f":"IF(AND(C68>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. Certificada EN 54-4\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
["MAD-472",{"$f":"VLOOKUP(\"Base sirena\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Sounder base"},null,{"$f":"107.4*10^-6","v":1.0739999999999999E-4},{"$f":"C69*D69","v":0},{"$f":"C69*'System Calculation'!$I$11","v":0},{"$f":"8.45*10^-3","v":8.4499999999999992E-3},0,0," ",null,null," "," "]
["MAD-473",{"$f":"VLOOKUP(\"Base sirena y flash\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Sounder base with beacon"},null,{"$f":"106.8*10^-6","v":1.0679999999999999E-4},0,{"$f":"C70*'System Calculation'!$I$11","v":0},{"$f":"9.48*10^-3","v":9.4800000000000006E-3},0,0," ",null,null," "," "]
["PAD-10A-I",{"$f":"VLOOKUP(\"Piloto indicador analógico con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable remote indicator with isolator"},null,{"$f":"176.4*10^-6","v":1.7640000000000001E-4},{"$f":"C71*D71","v":0},{"$f":"C71*'System Calculation'!$I$11","v":0},{"$f":"2.98*10^-3","v":2.98E-3},0,0,null,null,null,null,{"$f":"IF(C71<>0,C71,\" \")","v":" "}]
[{"$f":"VLOOKUP(\"TPLD-100 (CCD-102) = 3 dir. Lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"TPLD-100 (CCD-102) = 3 Loop dir."},{"$f":"VLOOKUP(\"Conexión central convencional 2 zonas\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Conventional control panel conection 2 zones"},null,{"$f":"1863*10^-6","v":1.8629999999999999E-3},0,{"$f":"C72","v":0},{"$f":"1.86*10^-3","v":1.8600000000000001E-3},0,0,null,null,null,null,{"$f":"IF(C72<>0,C72*3,\" \")","v":" "}]
[{"$f":"VLOOKUP(\"TPLD-100 (CCD-104) = 5 dir. Lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"TPLD-100 (CCD-104) = 5 Loop dir."},{"$f":"VLOOKUP(\"Conexión central convencional 4 zonas\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Conventional control panel conection 4 zones"},null,{"$f":"1863*10^-6","v":1.8629999999999999E-3},0,{"$f":"C73","v":0},{"$f":"1.86*10^-3","v":1.8600000000000001E-3},0,0,null,null,null,null,{"$f":"IF(C73<>0,C73*5,\" \")","v":" "}]
[{"$f":"VLOOKUP(\"TPLD-100 (CCD-108) = 9 dir. Lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"TPLD-100 (CCD-108) = 9 Loop dir."},{"$f":"VLOOKUP(\"Conexión central convencional 8 zonas\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Conventional control panel conection 8 zones"},null,1.8629999999999999E-3,0,0,1.8600000000000001E-3,0,0,null,null,null,null,{"$f":"IF(C74<>0,C74*9,\" \")","v":" "}]
[{"$f":"VLOOKUP(\"TPLD-100 (CCD-112) = 13 dir. Lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"TPLD-100 (CCD-112) = 13 Loop dir."},{"$f":"VLOOKUP(\"Conexión central convencional 12 zonas\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Conventional control panel conection 12 zones"},null,1.8629999999999999E-3,0,0,1.8600000000000001E-3,0,0,null,null,null,null,{"$f":"IF(C75<>0,C75*13,\" \")","v":" "}]
[{"$f":"VLOOKUP(\"TPLD-100 (CCD-103) = 7 dir. Lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"TPLD-100 (CCD-103) = 7 Loop dir."},{"$f":"VLOOKUP(\"Conexión central de extinción\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Extinguising control panel conection"},null,1.8629999999999999E-3,0,0,1.8600000000000001E-3,0,0,null,null,null,null,{"$f":"IF(C76<>0,C76*7,\" \")","v":" "}]
[{"$f":"VLOOKUP(\"Total\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Total"},null,{"$f":"SUM(C20:C76)","v":0},null,{"$f":"SUM(E20:E76)","v":0},{"$f":"SUM(F20:F70)","v":0},null,null,{"$f":"SUM(I20:I76)","v":0},0,0,0,0,0]
[null,null,{"$f":"IF($N$77>250,VLOOKUP(\"Error: El lazo no admite más de 250 direcciones\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\"\")","v":""}]
[]
[{"$f":"VLOOKUP(\"Parámetros de lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Loop parameters"}]
["Cu",1.72E-2,"Ω*mm2/m"]
[{"$f":"VLOOKUP(\"I_Reposo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"I_Standby"},{"$f":"E77+SUMIF(C77,\">0\",$R$9)/1000","v":0},"A"]
[{"$f":"VLOOKUP(\"I_Alarma\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"I_Alarm"},{"$f":"I77-J77","v":0},"A"]
[{"$f":"VLOOKUP(\"I_Sirenas\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"I_Sounders"},{"$f":"J77","v":0},"A"]
[{"$f":"VLOOKUP(\"I_Total\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"I_Total"},{"$f":"SUM(B83:B84)+SUMIF(C77,\">0\",$R$9)/1000","v":0},"A"]
[{"$f":"VLOOKUP(\"V_Lin_Anillo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"V_Lin_Ring"},{"$f":"IF(B85>0.1,7.9,IF(B106<1,6.9,7.9))","v":7.9},"V"]
[]
[{"$f":"VLOOKUP(\"Sección mínima de cable para longitudes estándar\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Minimum cable cross section for standard lenghts"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Aviso: La sección mínima de cable en el lazo es 0,5 mm2\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Warning: The minimum cross section in the loop is 0,5 mm2"}]
[{"$f":"VLOOKUP(\"Longitudes\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Lengths"},1000,1500,1500,2000,null,2000,null,2500,3000,3500,"m"]
[{"$f":"VLOOKUP(\"R_Cable\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"R_Cable"},{"$f":"((($B$81*B89)/B92)*2)","v":{"$error":"#DIV/0!"}},{"$f":"((($B$81*C89)/C92)*2)","v":{"$error":"#DIV/0!"}},{"$f":"((($B$81*D89)/D92)*2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Ω"]
[{"$f":"VLOOKUP(\"R_eq_Anillo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"R_eq_Ring"},{"$f":"B90/2","v":{"$error":"#DIV/0!"}},{"$f":"C90/2","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"I90/2","v":{"$error":"#DIV/0!"}},{"$f":"J90/2","v":{"$error":"#DIV/0!"}},{"$f":"K90/2","v":{"$error":"#DIV/0!"}},"Ω"]
[{"$f":"VLOOKUP(\"S_min\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"S_min"},{"$f":"IF((($B$81*B$89)/(($B$86-((SUM($C$21,$C$23,$C$25,$C$27)*0.1)*$B$85))/$B$85))<0.5,0.5,(($B$81*B$89)/(($B$86-((SUM($C$21,$C$23,$C$25,$C$27)*0.1)*$B$85))/$B$85)))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"mm2"]
[]
[{"$f":"VLOOKUP(\"Longitud máxima de cable para secciones estándar (IEC 60228)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Maximum cable length for standard cross sections (IEC 60228)"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Aviso: La sección mínima de cable en el lazo es 0,5 mm2\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Warning: The minimum cross section in the loop is 0,5 mm2"}]
[{"$f":"VLOOKUP(\"Sección\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Cross section"},0.5,0.75,0.75,1,null,1,null,1.5,2.5,4,"mm2"]
[{"$f":"VLOOKUP(\"R_Cable\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"R_Cable"},{"$f":"$B$81*B98/B95*2","v":{"$error":"#DIV/0!"}},{"$f":"$B$81*C98/C95*2","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Ω"]
[{"$f":"VLOOKUP(\"R_eq_Ring\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"R_eq_Ring"},{"$f":"B96/2","v":{"$error":"#DIV/0!"}},{"$f":"C96/2","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"I96/2","v":{"$error":"#DIV/0!"}},{"$f":"J96/2","v":{"$error":"#DIV/0!"}},{"$f":"K96/2","v":{"$error":"#DIV/0!"}},"Ω"]
[{"$f":"VLOOKUP(\"L_max\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"L_max"},{"$f":"IF((((($B$86-((SUM($C$21,$C$23,$C$25,$C$27)*0.1)*$B$85))/$B$85)*B$95)/$B$81)>3500,3500,(((($B$86-((SUM($C$21,$C$23,$C$25,$C$27)*0.1)*$B$85))/$B$85)*B$95)/$B$81))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"m"]
[]
[{"$f":"VLOOKUP(\"Cálculo Corriente Máxima\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Maximum current calculation"}]
[{"$f":"VLOOKUP(\"Sección de cable\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Cable cross section"},{"$f":"$B$10","v":0},"mm2",null,null,null,null,null,{"$f":"IF(B101<0.5,\"Error: La sección mínima de cable en el lazo es 0,5 mm2\",\"\")","v":"Error: La sección mínima de cable en el lazo es 0,5 mm2"}]
[{"$f":"VLOOKUP(\"Longitud efectiva de cable\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Effective cable length"},{"$f":"IF(B14=Data!D46,$B$11-MIN(B12,B13),$B$11)","v":0},"m",{"$f":"B12/B11","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(B13/B11,\"\")","v":""},{"$f":"(B11-B12-B13)/B11","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(B11>3500,VLOOKUP(\"Error: La longitud máxima de lazo es 3500 m\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\"\")","v":""}]
[{"$f":"VLOOKUP(\"R_Cable_Sis\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"R_Cable_Sys"},{"$f":"IFERROR(((($B$81*B102)/B101)*2)+(SUM(C21,C23,C25,C27,)*0.1),\"\")","v":""},"Ω"]
[{"$f":"VLOOKUP(\"R_eq_Clase\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"R_eq_Class"},{"$f":"IFERROR(B103*C14,\"\")","v":""},"Ω","Depende de la topología del lazo",{"$f":"VLOOKUP(\"Depende de la topología de lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Depends on the loop topology"}]
[{"$f":"VLOOKUP(\"R_eq_Final\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"R_eq_Final"},{"$f":"IFERROR((((($B$81*B11*F102)/B101)*2)+(SUM(C21,C23,C25,C27,)*0.1))*C14*C15+IF(B14=Data!D46,((($B$81*B11*(MAX(D102,E102))/B101)*2)*C14),((($B$81*B11*D102)/B101)*2)*C14+((($B$81*B11*E102)/B101)*2)*C14),\"\")","v":""},"Ω","Depende del factor de distribución",{"$f":"VLOOKUP(\"Depende del factor de distribución\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Depends on the distribution factor"}]
[{"$f":"VLOOKUP(\"Caída de tensión\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Voltage drop"},{"$f":"IFERROR(B85*B105,\"\")","v":""},"V"]
[{"$f":"VLOOKUP(\"Corriente máxima\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Maximum current"},{"$f":"IFERROR($B$86/$B$105-$R$9*10^-3,\"\")","v":""},"A"]
["I_max"]
[{"$f":"VLOOKUP(\"Comprobación sistema\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"System check"}]
[{"$f":"VLOOKUP(\"Corriente\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Consumption"},null,{"$f":"IFERROR(IF($B$85>0.75,VLOOKUP(\"FALLO\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),IF($B$107>=$B$85,\"OK\",\"FALLO\")),VLOOKUP(\"ERROR\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE))","v":"OK"},null,null,null,null,null,{"$f":"IFERROR(IF($B$85>0.75,VLOOKUP(\"Error: La corriente de lazo es mayor que la corriente máxima permitida\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),IF($B$107<$B$85,VLOOKUP(\"Error: La corriente de lazo es mayor que la corriente máxima permitida\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\"\")),VLOOKUP(\"ERROR: Los datos no son correctos\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE))","v":""}]
[{"$f":"VLOOKUP(\"Direcciones\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Directions"},null,{"$f":"IF($N$77<=250,VLOOKUP(\"OK\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),VLOOKUP(\"FALLO\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE))","v":"OK"},null,null,null,null,null,{"$f":"IF($N$77>250,VLOOKUP(\"Error: El lazo no admite más de 250 direcciones\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\"\")","v":""}]
[]
[]
[{"$f":"VLOOKUP(\"Esta herramienta se puede utilizar como ayuda de diseño para Detnov Security S.L.\",Translations!A4:E209,MATCH('System Calculation'!J7,Translations!A1:E1,0),FALSE)","v":"This tool may be used as a design help for Detnov Security S.L. We reserve the right not to be responsible for its accuracy, completeness or quality of the information provided, including any kind of information which could be incomplete or incorrect."}]

{"sheet":"SC_Loop 2","index":2,"n_rows":114,"n_cols":31,"rows_kept":114,"cut":false,"hidden":false,"merged":[[113,0,113,13],[11,3,12,12],[8,11,8,13],[9,8,10,10],[9,11,9,12],[10,11,10,12]]}
[]
[]
[]
[]
[{"$f":"'System Calculation'!A7","v":"SYSTEM CALCULATOR DETNOV CAD-151"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'System Calculation'!L7","v":"SC 688 m 2025 b"}]
[]
[{"$f":"VLOOKUP(\"Cumplimentar Sección de cable en mm2 y Longitud de lazo en metros (campo amarillo)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Fill Cable cross section in mm2 and Loop length in meters"}]
[{"$f":"VLOOKUP(\"Seleccionar el factor de distribución en el lazo y topología de clase\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Select the distribution factor in the loop and the topology"}]
[{"$f":"VLOOKUP(\"Lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Loop"},null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Comprobación sistema\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"System check"},null,null,null,{"$f":"VLOOKUP(\"Trama comunicaciones\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Communication frame"},null,26]
[{"$f":"VLOOKUP(\"Sección de cable\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Cable cross section"},null,{"$f":"IFERROR(VLOOKUP($B$10,Data!$H$17:$I$23,2,FALSE),\"ERROR\")","v":"ERROR"},null,null,null,null,null,{"$f":"IF(B11>3500,VLOOKUP(\"Error: La longitud máxima de lazo es 3500 m\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\"\")","v":""},null,null,{"$f":"VLOOKUP(\"Corriente\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Consumption"},null,{"$f":"IFERROR(IF($B$85>0.75,VLOOKUP(\"FALLO\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),IF($B$107>=$B$85,\"OK\",\"FALLO\")),VLOOKUP(\"ERROR\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE))","v":"OK"},null,{"$f":"IFERROR(IF($B$85>0.75,VLOOKUP(\"Error: La corriente de lazo es mayor que la corriente máxima permitida\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),IF($B$107<$B$85,VLOOKUP(\"Error: La corriente de lazo es mayor que la corriente máxima permitida\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\"\")),VLOOKUP(\"ERROR: Los datos no son correctos\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE))","v":""}]
[{"$f":"VLOOKUP(\"Longitud de lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Loop length"},null,{"$f":"VLOOKUP(\"metros\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"meters"},null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Direcciones\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Directions"},null,{"$f":"IF($N$77<=250,VLOOKUP(\"OK\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),VLOOKUP(\"FALLO\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE))","v":"OK"},null,{"$f":"IF($N$77>250,VLOOKUP(\"Error: El lazo no admite más de 250 direcciones\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Información\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Information"}]
[{"$f":"VLOOKUP(\"Distancia de S al primer dispositivo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Distance from S to first device"},null,{"$f":"VLOOKUP(\"metros\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"meters"},{"$f":"IF(B12+B13>B11,VLOOKUP(\"La suma de distancias desde la central a los dipositivos no puede ser mayor a la longitud de lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(P13<>\"\",VLOOKUP(\"Indicaciones\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\"\"),VLOOKUP(\"Indicaciones\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Esta es la distancia de la salida del lazo hasta el primer dispositivo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"This is the distance from the S of the loop to the first device"}]
[{"$f":"VLOOKUP(\"Distancia de R al último dispositivo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Distance from R to last device"},null,{"$f":"VLOOKUP(\"metros\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"meters"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($N$77>250,VLOOKUP(\"Reduzca el número de direcciones utilizadas\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),IF($B$85>0.75,VLOOKUP(\"Trate de reducir el consumo ajustando la cantidad de dispositivos\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),IF($B$107<$B$85,VLOOKUP(\"Trate de modificar los parámetros de cable y lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\"\"))),VLOOKUP(\"Revise o rellene los datos de configuración de lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Esta es la distancia del último dispositivo al retorno del lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"This is the distance from the last device to the R of the loop"}]
[{"$f":"VLOOKUP(\"Topología de lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Loop topology"},null,{"$f":"IFERROR(VLOOKUP(B14,Data!$D$45:$E$46,2,FALSE),\"ERROR\")","v":"ERROR"},null,{"$f":"IF($B$14=Data!D46,VLOOKUP(\"Lazo abierto. Toda la corriente en el mismo extremo del cable (peor caso)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),VLOOKUP(\"Lazo cerrado. Se divide la corriente por los dos extremos (mejor caso)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE))","v":"Closed loop. The current is divided on both ends (best case)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"La topología de lazo hace referencia\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Loop topology takes into account whether the loop is closed in Class A, or the loop is in degraded mode due to an open loop fault "}]
[{"$f":"VLOOKUP(\"Factor de distribución\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Distribution factor"},1,{"$f":"VLOOKUP(B15,Data!$A$21:$B$49,2,FALSE)","v":0.56999999999999995},null,{"$f":"IF($B$15=1,VLOOKUP(\"Distribuidos equitativamente (mejor caso)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),IF($B$15=0,VLOOKUP(\"Todos en el mismo extremo del cable (peor caso)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),VLOOKUP(\"Caso intermedio\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)))","v":"Equally distributed (best case)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"El factor de distribución hace referencia\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Distribution factor is an estimation of how equitative are the devices distributed along the loop, being 100% perfectly distributed"}]
[]
[null,null,{"$f":"VLOOKUP(\"Cumplimentar el campo PCS para la configuración deseada (campo amarillo)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Fill the PCS field for the desired configuration"}]
[{"$f":"VLOOKUP(\"Dispositivos lazo 2\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Loop 2 devices"}]
[{"$f":"VLOOKUP(\"REF.\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"REF."},{"$f":"VLOOKUP(\"Descripción\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Description"},{"$f":"VLOOKUP(\"PCS\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"PCS"},"I_Standby (A)",{"$f":"VLOOKUP(\"I_Reposo (A)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"I_Standby (A)"},"PCS_alarm","I_Alarm (A)","I_Alarm_aux (A)",{"$f":"VLOOKUP(\"I_Alarma (A)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"I_Alarm (A)"},{"$f":"VLOOKUP(\"I_Sirenas (A)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"I_Sounders (A)"},{"$f":"VLOOKUP(\"DET\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"DET"},{"$f":"VLOOKUP(\"MOD\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MOD"},{"$f":"VLOOKUP(\"SIR\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"SND"},{"$f":"VLOOKUP(\"DIR\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"DIR"}]
["DOD-220A",{"$f":"VLOOKUP(\"Detector óptico analógico\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable optical smoke detector"},null,{"$f":"127.2*10^-6","v":1.272E-4},{"$f":"C20*D20","v":0},{"$f":"IFERROR(INDEX($AE$22:$AE$37,MATCH(H20,$AB$22:$AB$37,0)),0)","v":0},{"$f":"3.61*10^-3","v":3.6099999999999999E-3},{"$f":"IF(C20>0,G20+ROW(G20)/100000000000,0)","v":0},{"$f":"IF(F20>0,F20*G20+(C20-F20)*D20,C20*D20)","v":0},null,{"$f":"IF(C20<>0,C20,\" \")","v":" "},null,null,{"$f":"IF(K20<>0,K20,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,"* Si no quiero que algún dispositivo esté aquí, poner a 0 su valor en columna H"]
["DOD-220A-I",{"$f":"VLOOKUP(\"Detector óptico analógico con aislador incorporado\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable optical smoke detector with built-in isolator"},null,{"$f":"195.8*10^-6","v":1.9580000000000002E-4},{"$f":"C21*D21","v":0},0,{"$f":"3.74*10^-3","v":3.7400000000000003E-3},{"$f":"IF(C21>0,G21+ROW(G21)/100000000000,0)","v":0},{"$f":"IF(F21>0,F21*G21+(C21-F21)*D21,C21*D21)","v":0},null," ",null,null,{"$f":"IF(K21<>0,K21,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,"Orden","Valor","PCS","Cuantos quedan para 16","PCS alarma"]
["DOTD-230A",{"$f":"VLOOKUP(\"Detector óptico-térmico\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable optical & heat detector"},null,{"$f":"141.6*10^-6","v":1.416E-4},{"$f":"C22*D22","v":0},0,{"$f":"3.6*10^-3","v":3.6000000000000003E-3},0,0,null," ",null,null,{"$f":"IF(K22<>0,K22,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"LARGE($H$20:$H$53,AA22)","v":0},{"$f":"INDEX(C:C,MATCH(AB22,H:H,0))","v":0},{"$f":"IF(16-AC22>0,16-AC22,0)","v":16},{"$f":"IF(AD22>0,AC22,16)","v":0}]
["DOTD-230A-I",{"$f":"VLOOKUP(\"Detector óptico-térmico con aislador incorporado\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable optical & heat detector with built-in isolator"},null,{"$f":"212.4*10^-6","v":2.1239999999999999E-4},0,0,{"$f":"3.74*10^-3","v":3.7400000000000003E-3},0,0,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,2,0,0,{"$f":"IF(AD22-AC23>0,AD22-AC23,0)","v":16},{"$f":"IF(AD23>0,AC23,AD22)","v":0}]
["DTD-210A",{"$f":"VLOOKUP(\"Detector térmico analógico\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable heat detector"},null,{"$f":"122.2*10^-6","v":1.2219999999999999E-4},0,0,{"$f":"3.64*10^-3","v":3.64E-3},0,0,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,3,0,0,{"$f":"IF(AD23-AC24>0,AD23-AC24,0)","v":16},{"$f":"IF(AD24>0,AC24,AD23)","v":0}]
["DTD-210A-I",{"$f":"VLOOKUP(\"Detector térmico analógico con aislador incorporado\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable heat detector with built-in isolator"},null,{"$f":"192.4*10^-6","v":1.9239999999999999E-4},0,0,{"$f":"3.76*10^-3","v":3.7599999999999999E-3},0,0,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,4,0,0,16,0]
["DTD-215A",{"$f":"VLOOKUP(\"Detector térmico de alta temperatura analógico\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable high temperature detector"},null,{"$f":"133.7*10^-6","v":1.3369999999999997E-4},0,0,{"$f":"3.78*10^-3","v":3.7799999999999999E-3},0,0,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,5,0,0,16,0]
["DTD-215A-I",{"$f":"VLOOKUP(\"Detector térmico de alta temperatura analógico con aislador incorporado\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable high temperature detector with built-in isolator"},null,{"$f":"203.5*10^-6","v":2.0349999999999999E-4},0,0,{"$f":"3.77*10^-3","v":3.7699999999999999E-3},0,0,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,6,0,0,16,0]
["DGD-600",{"$f":"VLOOKUP(\"Detector autónomo de gas natural (24V)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Standalone natural gas detector (24V)"},null,{"$f":"2180*10^-6","v":2.1800000000000001E-3},0,0,{"$f":"2.22*10^-3","v":2.2200000000000002E-3},0,0,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,7,0,0,16,0]
["DGD-600-AC",{"$f":"VLOOKUP(\"Detector autónomo de gas natural (230V)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Standalone natural gas detector (230V)"},null,{"$f":"2600*10^-6","v":2.5999999999999999E-3},0,0,{"$f":"3.16*10^-3","v":3.16E-3},0,0,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,8,0,0,16,0]
["DGD-620",{"$f":"VLOOKUP(\"Detector autónomo de GLP (24V)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Standalone LPG detector (24V)"},null,{"$f":"2180*10^-6","v":2.1800000000000001E-3},0,0,{"$f":"2.22*10^-3","v":2.2200000000000002E-3},0,0,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,9,0,0,16,0]
["DGD-620-AC",{"$f":"VLOOKUP(\"Detector autónomo de GLP (230V)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Standalone LPG detector (230V)"},null,{"$f":"2600*10^-6","v":2.5999999999999999E-3},0,0,{"$f":"3.16*10^-3","v":3.16E-3},0,0,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,10,0,0,16,0]
["DBD-70A",{"$f":"VLOOKUP(\"Detector lineal de humos analógico\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable beam smoke detector"},null,4.0000000000000001E-3,0,{"$f":"C32","v":0},4.0000000000000001E-3,{"$f":"0","v":0},{"$f":"IF(F32>0,F32*G32+(C32-F32)*D32,C32*D32)","v":0},null," ",null,null," ",null,{"$f":"IF(C32>20,VLOOKUP(\"Info: El máximo número de barreras es 20\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),IF(C32>0,VLOOKUP(\"Info: Alinear barreras de una en una\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \"))","v":" "},null,null,null,null,null,null,null,null,null,null,11,0,0,16,0]
["MAD-401 & MAD-401-I",{"$f":"VLOOKUP(\"Módulo analógico de 1 entrada (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 1 input (with/without isolator)"},null,{"$f":"216.8*10^-6","v":2.1680000000000001E-4},0,{"$f":"IFERROR(INDEX($AE$22:$AE$37,MATCH(H33,$AB$22:$AB$37,0)),0)","v":0},{"$f":"3.06*10^-3","v":3.0600000000000002E-3},0,0,null,null,{"$f":"IF(C33<>0,C33,\" \")","v":" "},null,{"$f":"IF(L33<>0,L33,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,12,0,0,16,0]
["MAD-402 & MAD-402-I",{"$f":"VLOOKUP(\"Módulo analógico de 2 entradas (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 2 inputs (with/without isolator)"},null,{"$f":"217.4*10^-6","v":2.174E-4},{"$f":"C34*D34","v":0},0,{"$f":"5.95*10^-3","v":5.9500000000000004E-3},0,0,null,null,{"$f":"IF(C34<>0,C34,0)","v":0},null,{"$f":"IF(L34<>0,L34*2,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,13,0,0,16,0]
["MAD-405-I",{"$f":"VLOOKUP(\"Módulo analógico de 5 entradas con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 5 inputs with isolator"},null,{"$f":"278.6*10^-6","v":2.786E-4},0,0,{"$f":"3.15*10^-3","v":3.15E-3},0,0,null,null,{"$f":"IF(C35<>0,C35,0)","v":0},null,{"$f":"IF(L35<>0,L35*5,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,14,0,0,16,0]
["MAD-409-I",{"$f":"VLOOKUP(\"Módulo analógico de 10 entradas con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 10 inputs with isolator"},null,{"$f":"367.7*10^-6","v":3.6769999999999999E-4},0,0,{"$f":"3.3*10^-3","v":3.3E-3},0,0,null,null,{"$f":"IF(C36<>0,C36,0)","v":0},null,{"$f":"IF(L36<>0,L36*10,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,16,0]
["MAD-411 & MAD-411-I",{"$f":"VLOOKUP(\"Módulo analógico de 1 salida (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 1 output (with/without isolator)"},null,{"$f":"191.6*10^-6","v":1.916E-4},0,0,{"$f":"3.06*10^-3","v":3.0600000000000002E-3},0,0,null,null,{"$f":"IF(C37<>0,C37,\" \")","v":" "},null,{"$f":"IF(L37<>0,L37,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,16,0,0,16,0]
["MAD-412 & MAD-412-I",{"$f":"VLOOKUP(\"Módulo analógico de 2 salidas (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 2 outputs (with/without isolator)"},null,{"$f":"191*10^-6","v":1.9099999999999998E-4},0,0,{"$f":"5.84*10^-3","v":5.8399999999999997E-3},0,0,null,null,{"$f":"IF(C38<>0,C38,0)","v":0},null,{"$f":"IF(L38<>0,L38*2,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(AC22:AC37)","v":0},null,{"$f":"SUM(AE22:AE37)","v":0}]
["MAD-415-I",{"$f":"VLOOKUP(\"Módulo analógico de 5 salidas con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 5 outputs with isolator"},null,{"$f":"188.8*10^-6","v":1.8880000000000001E-4},0,0,{"$f":"3.95*10^-3","v":3.9500000000000004E-3},0,0,null,null,0,null,{"$f":"IF(L39<>0,L39*5,\" \")","v":" "},null,{"$f":"IF(AND(C39>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. La central puede dar 24Vaux, si la corriente máxima 500mA no es excedida.\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
["MAD-419-I",{"$f":"VLOOKUP(\"Módulo analógico de 10 salidas con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 10 outputs with isolator"},null,{"$f":"189.2*10^-6","v":1.8919999999999999E-4},0,0,{"$f":"4.84*10^-3","v":4.8399999999999997E-3},0,0,null,null,0,null,{"$f":"IF(L40<>0,L40*10,\" \")","v":" "},null,{"$f":"IF(AND(C40>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. La central puede dar 24Vaux, si la corriente máxima 500mA no es excedida.\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
["MAD-421 & MAD-421-I",{"$f":"VLOOKUP(\"Módulo analógico de 1 entrada/1 salida (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 1 input/1 output (with/without isolator)"},null,{"$f":"210.1*10^-6","v":2.1009999999999998E-4},0,0,{"$f":"5.92*10^-3","v":5.9199999999999999E-3},0,0,null,null,0,null,{"$f":"IF(L41<>0,L41*2,\" \")","v":" "}]
["MAD-422 & MAD-422-I",{"$f":"VLOOKUP(\"Módulo analógico de 2 entradas/2 salidas (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 2 inputs/2 outputs (with/without isolator)"},null,{"$f":"234*10^-6","v":2.34E-4},0,0,{"$f":"5.91*10^-3","v":5.9100000000000003E-3},0,0,null,null,0,null,{"$f":"IF(L42<>0,L42*4,\" \")","v":" "}]
["MAD-425-I",{"$f":"VLOOKUP(\"Módulo analógico de 5 entradas/5 salidas con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 5 inputs/5 outputs with isolator"},null,{"$f":"284*10^-6","v":2.8399999999999996E-4},0,0,{"$f":"4.08*10^-3","v":4.0800000000000003E-3},0,0,null,null,0,null,{"$f":"IF(L43<>0,L43*10,\" \")","v":" "},null,{"$f":"IF(AND(C43>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. La central puede dar 24Vaux, si la corriente máxima 500mA no es excedida.\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
["MAD-429-I",{"$f":"VLOOKUP(\"Módulo analógico de 10 entradas/10 salidas con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 10 inputs/10 outputs with isolator"},null,{"$f":"376.6*10^-6","v":3.7659999999999999E-4},0,0,{"$f":"5*10^-3","v":5.0000000000000001E-3},0,0,null,null,0,null,{"$f":"IF(L44<>0,L44*20,\" \")","v":" "},null,{"$f":"IF(AND(C44>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. La central puede dar 24Vaux, si la corriente máxima 500mA no es excedida.\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
["MAD-431 & MAD-431-I",{"$f":"VLOOKUP(\"Módulo analógico de 1 salida 24V (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 1 24V output (with/without isolator)"},null,{"$f":"215*10^-6","v":2.1499999999999999E-4},0,0,{"$f":"3.61*10^-3","v":3.6099999999999999E-3},0,0,null,null,0,null,{"$f":"IF(L45<>0,L45,\" \")","v":" "},null,{"$f":"IF(AND(C45>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. La central puede dar 24Vaux, si la corriente máxima 500mA no es excedida.\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
["MAD-432 & MAD-432-I",{"$f":"VLOOKUP(\"Módulo analógico de 2 salidas 24V (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 2 24V outputs (with/without isolator)"},null,{"$f":"203.3*10^-6","v":2.0330000000000001E-4},0,0,{"$f":"6.8*10^-3","v":6.7999999999999996E-3},0,0,null,null,0,null,{"$f":"IF(L46<>0,L46*2,\" \")","v":" "},null,{"$f":"IF(AND(C46>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. La central puede dar 24Vaux, si la corriente máxima 500mA no es excedida.\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
["MAD-441 & MAD-441-I",{"$f":"VLOOKUP(\"Módulo analógico de 1 zona convencional (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 1 conventional zone (with/without isolator)"},null,{"$f":"187.8*10^-6","v":1.8780000000000001E-4},0,0,{"$f":"3.04*10^-3","v":3.0400000000000002E-3},0,0,null,null,0,null,{"$f":"IF(L47<>0,L47,\" \")","v":" "},null,{"$f":"IF(AND(C47>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. La central puede dar 24Vaux, si la corriente máxima 500mA no es excedida.\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
["MAD-442 & MAD-442-I",{"$f":"VLOOKUP(\"Módulo analógico de 2 zonas convencionales (sin/con aislador)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 2 conventional zones (with/without isolator)"},null,{"$f":"187.8*10^-6","v":1.8780000000000001E-4},0,0,{"$f":"5.84*10^-3","v":5.8399999999999997E-3},0,0,null,null,0,null,{"$f":"IF(L48<>0,L48*2,\" \")","v":" "},null,{"$f":"IF(AND(C48>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. La central puede dar 24Vaux, si la corriente máxima 500mA no es excedida.\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
["MAD-481",{"$f":"VLOOKUP(\"Módulo analógico de 1 salida 230V\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module 1 230V output"},null,1.176E-4,0,0,2.8800000000000002E-3,0,0,null,null,0,null,{"$f":"IF(L49<>0,L49,\" \")","v":" "}]
["MAD-490",{"$f":"VLOOKUP(\"Módulo analógico aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable module isolator"},null,{"$f":"69.6*10^-6","v":6.9599999999999998E-5},0,0,{"$f":"37.66*10^-3","v":3.7659999999999999E-2},0,0,null,null,0,null,{"$f":"IF(L50<>0,L50,\" \")","v":" "}]
["MAD-450 & MAD-450-I",{"$f":"VLOOKUP(\"Pulsador analógico con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable manual call with isolator"},null,{"$f":"176.6*10^-6","v":1.7659999999999998E-4},0,0,{"$f":"3.03*10^-3","v":3.0299999999999997E-3},0,0,null,null,0,null,{"$f":"IF(C51<>0,C51,\" \")","v":" "}]
["MAD-451-I",{"$f":"VLOOKUP(\"Pulsador analógico con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable manual call with isolator"},null,{"$f":"177.4*10^-6","v":1.774E-4},0,0,{"$f":"3*10^-3","v":3.0000000000000001E-3},0,0,null,null,0,null,{"$f":"IF(C52<>0,C52,\" \")","v":" "}]
["MAD-452 & MAD-452-I",{"$f":"VLOOKUP(\"Pulsador analógico con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable manual call with isolator"},null,3.4099999999999999E-4,0,0,1.81E-3,0,0,null,null,0,null,{"$f":"IF(C53<>0,C53,\" \")","v":" "}]
["MAD-461-I",{"$f":"VLOOKUP(\"Sirena analógica con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable sounder with isolator"},null,{"$f":"176.9*10^-6","v":1.7689999999999999E-4},0,{"$f":"C54*'System Calculation'!$I$11","v":0},{"$f":"8.35*10^-3","v":8.3499999999999998E-3},0,{"$f":"IF(F54>0,F54*G54+(C54-F54)*D54,C54*D54)","v":0},{"$f":"IF(C54*I54=0,\" \",I54)","v":" "},null,null,{"$f":"IF(C54<>0,C54,\" \")","v":" "},{"$f":"IF(M54<>0,M54,\" \")","v":" "}]
["MAD-464-I",{"$f":"VLOOKUP(\"Sirena analógica con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable sounder with isolator"},null,{"$f":"176.5*10^-6","v":1.7649999999999998E-4},0,{"$f":"C55*'System Calculation'!$I$11","v":0},{"$f":"12.32*10^-3","v":1.2320000000000001E-2},0,0," ",null,null," ",{"$f":"IF(M55<>0,M55,\" \")","v":" "}]
["MAD-465-I",{"$f":"VLOOKUP(\"Sirena analógica con flash y aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable sounder with beacon and isolator"},null,{"$f":"177.3*10^-6","v":1.773E-4},0,{"$f":"C56*'System Calculation'!$I$11","v":0},1.2320000000000001E-2,0,0," ",null,null," "," "]
[{"$f":"VLOOKUP(\"MAD-564-I (lazo)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-564-I (loop)"},{"$f":"VLOOKUP(\"Sirena analógica con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable sounder with isolator"},null,{"$f":"1580*10^-6","v":1.58E-3},0,{"$f":"C57*'System Calculation'!$I$11","v":0},{"$f":"21.11*10^-3","v":2.111E-2},0,0," ",null,null," "," "]
[{"$f":"VLOOKUP(\"MAD-564-I (FA externa)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-564-I (external PS)"},{"$f":"VLOOKUP(\"Sirena analógica con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable sounder with isolator"},null,{"$f":"350*10^-6","v":3.5E-4},0,{"$f":"C58*'System Calculation'!$I$11","v":0},{"$f":"0.8*10^-3","v":8.0000000000000004E-4},0,0," ",null,null," "," ",null,{"$f":"IF(AND(C58>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. Certificada EN 54-4\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
[{"$f":"VLOOKUP(\"MAD-565-I (lazo)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-565-I (loop)"},{"$f":"VLOOKUP(\"Sirena analógica con VAD y aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable sounder with VAD and isolator"},null,{"$f":"1580*10^-6","v":1.58E-3},0,{"$f":"C59*'System Calculation'!$I$11","v":0},{"$f":"33.45*10^-3","v":3.3450000000000001E-2},0,0," ",null,null," "," "]
[{"$f":"VLOOKUP(\"MAD-565-I (FA externa)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-565-I (external PS)"},{"$f":"VLOOKUP(\"Sirena analógica con VAD y aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable sounder with VAD and isolator"},null,{"$f":"350*10^-6","v":3.5E-4},0,{"$f":"C60*'System Calculation'!$I$11","v":0},{"$f":"0.8*10^-3","v":8.0000000000000004E-4},0,0," ",null,null," "," ",null,{"$f":"IF(AND(C60>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. Certificada EN 54-4\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
[{"$f":"VLOOKUP(\"MAD-565-I - solo flash (lazo)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-565-I - only flash (loop)"},{"$f":"VLOOKUP(\"VAD analógico con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable VAD with isolator"},null,{"$f":"1580*10^-6","v":1.58E-3},{"$f":"C61*D61","v":0},{"$f":"C61*'System Calculation'!$I$11","v":0},{"$f":"33.45*10^-3","v":3.3450000000000001E-2},0,0," ",null,null," "," "]
[{"$f":"VLOOKUP(\"MAD-565-I - solo flash (FA externa)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-565-I - only flash (external PS)"},{"$f":"VLOOKUP(\"VAD analógico con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable VAD with isolator"},null,{"$f":"350*10^-6","v":3.5E-4},{"$f":"C62*D62","v":0},{"$f":"C62*'System Calculation'!$I$11","v":0},{"$f":"0.8*10^-3","v":8.0000000000000004E-4},0,0," ",null,null," "," ",null,{"$f":"IF(AND(C62>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. Certificada EN 54-4\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
[{"$f":"VLOOKUP(\"MAD-567-I (lazo)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-567-I (loop)"},{"$f":"VLOOKUP(\"Base sirena con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Sounder base with isolator"},null,{"$f":"1170*10^-6","v":1.17E-3},0,{"$f":"C63*'System Calculation'!$I$11","v":0},{"$f":"8.95*10^-3","v":8.9499999999999996E-3},0,0," ",null,null," "," "]
[{"$f":"VLOOKUP(\"MAD-567-I (FA externa)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-567-I (external PS)"},{"$f":"VLOOKUP(\"Base sirena con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Sounder base with isolator"},null,{"$f":"261*10^-6","v":2.61E-4},0,{"$f":"C64*'System Calculation'!$I$11","v":0},{"$f":"0.71*10^-3","v":7.1000000000000002E-4},0,0," ",null,null," "," ",null,{"$f":"IF(AND(C64>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. Certificada EN 54-4\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
[{"$f":"VLOOKUP(\"MAD-569-I (lazo)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-569-I (loop)"},{"$f":"VLOOKUP(\"Base sirena y VAD con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Sounder base and VAD with isolator"},null,{"$f":"1170*10^-6","v":1.17E-3},0,{"$f":"C65*'System Calculation'!$I$11","v":0},{"$f":"23.26*10^-3","v":2.3260000000000003E-2},0,0," ",null,null," "," "]
[{"$f":"VLOOKUP(\"MAD-569-I (FA externa)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-569-I (external PS)"},{"$f":"VLOOKUP(\"Base sirena y VAD con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Sounder base and VAD with isolator"},null,{"$f":"258.9*10^-6","v":2.5889999999999995E-4},0,{"$f":"C66*'System Calculation'!$I$11","v":0},{"$f":"0.71*10^-3","v":7.1000000000000002E-4},0,0," ",null,null," "," ",null,{"$f":"IF(AND(C66>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. Certificada EN 54-4\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
[{"$f":"VLOOKUP(\"MAD-569-I - solo flash (lazo)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-569-I - only flash (loop)"},{"$f":"VLOOKUP(\"Base VAD con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"VAD base with isolator"},null,{"$f":"1170*10^-6","v":1.17E-3},0,{"$f":"C67*'System Calculation'!$I$11","v":0},{"$f":"23.26*10^-3","v":2.3260000000000003E-2},0,0," ",null,null," "," "]
[{"$f":"VLOOKUP(\"MAD-569-I solo flash (FA externa)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"MAD-569-I only flash (external PS)"},{"$f":"VLOOKUP(\"Base VAD con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"VAD base with isolator"},null,{"$f":"258.9*10^-6","v":2.5889999999999995E-4},0,{"$f":"C68*'System Calculation'!$I$11","v":0},{"$f":"0.71*10^-3","v":7.1000000000000002E-4},0,0," ",null,null," "," ",null,{"$f":"IF(AND(C68>0),VLOOKUP(\"Info: Fuente externa 24V necesaria. Certificada EN 54-4\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\" \")","v":" "}]
["MAD-472",{"$f":"VLOOKUP(\"Base sirena\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Sounder base"},null,{"$f":"107.4*10^-6","v":1.0739999999999999E-4},{"$f":"C69*D69","v":0},{"$f":"C69*'System Calculation'!$I$11","v":0},{"$f":"8.45*10^-3","v":8.4499999999999992E-3},0,0," ",null,null," "," "]
["MAD-473",{"$f":"VLOOKUP(\"Base sirena y flash\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Sounder base with beacon"},null,{"$f":"106.8*10^-6","v":1.0679999999999999E-4},0,{"$f":"C70*'System Calculation'!$I$11","v":0},{"$f":"9.48*10^-3","v":9.4800000000000006E-3},0,0," ",null,null," "," "]
["PAD-10A-I",{"$f":"VLOOKUP(\"Piloto indicador analógico con aislador\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Addressable remote indicator with isolator"},null,{"$f":"176.4*10^-6","v":1.7640000000000001E-4},0,{"$f":"C71*'System Calculation'!$I$11","v":0},{"$f":"2.98*10^-3","v":2.98E-3},0,0,null,null,null,null,{"$f":"IF(C71<>0,C71,\" \")","v":" "}]
[{"$f":"VLOOKUP(\"TPLD-100 (CCD-102) = 3 dir. Lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"TPLD-100 (CCD-102) = 3 Loop dir."},{"$f":"VLOOKUP(\"Conexión central convencional 2 zonas\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Conventional control panel conection 2 zones"},null,{"$f":"1863*10^-6","v":1.8629999999999999E-3},0,{"$f":"C72","v":0},{"$f":"1.86*10^-3","v":1.8600000000000001E-3},0,0,null,null,null,null,{"$f":"IF(C72<>0,C72*3,\" \")","v":" "}]
[{"$f":"VLOOKUP(\"TPLD-100 (CCD-104) = 5 dir. Lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"TPLD-100 (CCD-104) = 5 Loop dir."},{"$f":"VLOOKUP(\"Conexión central convencional 4 zonas\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Conventional control panel conection 4 zones"},null,{"$f":"1863*10^-6","v":1.8629999999999999E-3},0,{"$f":"C73","v":0},{"$f":"1.86*10^-3","v":1.8600000000000001E-3},0,0,null,null,null,null,{"$f":"IF(C73<>0,C73*5,\" \")","v":" "}]
[{"$f":"VLOOKUP(\"TPLD-100 (CCD-108) = 9 dir. Lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"TPLD-100 (CCD-108) = 9 Loop dir."},{"$f":"VLOOKUP(\"Conexión central convencional 8 zonas\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Conventional control panel conection 8 zones"},null,1.8629999999999999E-3,0,0,1.8600000000000001E-3,0,0,null,null,null,null,{"$f":"IF(C74<>0,C74*9,\" \")","v":" "}]
[{"$f":"VLOOKUP(\"TPLD-100 (CCD-112) = 13 dir. Lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"TPLD-100 (CCD-112) = 13 Loop dir."},{"$f":"VLOOKUP(\"Conexión central convencional 12 zonas\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Conventional control panel conection 12 zones"},null,1.8629999999999999E-3,0,0,1.8600000000000001E-3,0,0,null,null,null,null,{"$f":"IF(C75<>0,C75*13,\" \")","v":" "}]
[{"$f":"VLOOKUP(\"TPLD-100 (CCD-103) = 7 dir. Lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"TPLD-100 (CCD-103) = 7 Loop dir."},{"$f":"VLOOKUP(\"Conexión central de extinción\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Extinguising control panel conection"},null,1.8629999999999999E-3,0,0,1.8600000000000001E-3,0,0,null,null,null,null,{"$f":"IF(C76<>0,C76*7,\" \")","v":" "}]
[{"$f":"VLOOKUP(\"Total\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Total"},null,{"$f":"SUM(C20:C76)","v":0},null,{"$f":"SUM(E20:E76)","v":0},{"$f":"SUM(F20:F70)","v":0},null,null,{"$f":"SUM(I20:I76)","v":0},0,0,0,0,0]
[null,null,{"$f":"IF($N$77>250,VLOOKUP(\"Error: El lazo no admite más de 250 direcciones\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\"\")","v":""}]
[]
[{"$f":"VLOOKUP(\"Parámetros de lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Loop parameters"}]
["Cu",1.72E-2,"Ω*mm2/m"]
[{"$f":"VLOOKUP(\"I_Reposo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"I_Standby"},{"$f":"E77+SUMIF(C77,\">0\",$R$9)/1000","v":0},"A"]
[{"$f":"VLOOKUP(\"I_Alarma\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"I_Alarm"},{"$f":"I77-J77","v":0},"A"]
[{"$f":"VLOOKUP(\"I_Sirenas\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"I_Sounders"},{"$f":"J77","v":0},"A"]
[{"$f":"VLOOKUP(\"I_Total\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"I_Total"},{"$f":"SUM(B83:B84)+SUMIF(C77,\">0\",$R$9)/1000","v":0},"A"]
[{"$f":"VLOOKUP(\"V_Lin_Anillo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"V_Lin_Ring"},{"$f":"IF(B85>0.1,7.9,IF(B106<1,6.9,7.9))","v":7.9},"V"]
[]
[{"$f":"VLOOKUP(\"Sección mínima de cable para longitudes estándar\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Minimum cable cross section for standard lenghts"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Aviso: La sección mínima de cable en el lazo es 0,5 mm2\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Warning: The minimum cross section in the loop is 0,5 mm2"}]
[{"$f":"VLOOKUP(\"Longitudes\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Lengths"},1000,1500,1500,2000,null,2000,null,2500,3000,3500,"m"]
[{"$f":"VLOOKUP(\"R_Cable\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"R_Cable"},{"$f":"((($B$81*B89)/B92)*2)","v":{"$error":"#DIV/0!"}},{"$f":"((($B$81*C89)/C92)*2)","v":{"$error":"#DIV/0!"}},{"$f":"((($B$81*D89)/D92)*2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Ω"]
[{"$f":"VLOOKUP(\"R_eq_Anillo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"R_eq_Ring"},{"$f":"B90/2","v":{"$error":"#DIV/0!"}},{"$f":"C90/2","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"I90/2","v":{"$error":"#DIV/0!"}},{"$f":"J90/2","v":{"$error":"#DIV/0!"}},{"$f":"K90/2","v":{"$error":"#DIV/0!"}},"Ω"]
[{"$f":"VLOOKUP(\"S_min\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"S_min"},{"$f":"IF((($B$81*B$89)/(($B$86-((SUM($C$21,$C$23,$C$25,$C$27)*0.1)*$B$85))/$B$85))<0.5,0.5,(($B$81*B$89)/(($B$86-((SUM($C$21,$C$23,$C$25,$C$27)*0.1)*$B$85))/$B$85)))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"mm2"]
[]
[{"$f":"VLOOKUP(\"Longitud máxima de cable para secciones estándar (IEC 60228)\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Maximum cable length for standard cross sections (IEC 60228)"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Aviso: La sección mínima de cable en el lazo es 0,5 mm2\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Warning: The minimum cross section in the loop is 0,5 mm2"}]
[{"$f":"VLOOKUP(\"Sección\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Cross section"},0.5,0.75,0.75,1,null,1,null,1.5,2.5,4,"mm2"]
[{"$f":"VLOOKUP(\"R_Cable\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"R_Cable"},{"$f":"$B$81*B98/B95*2","v":{"$error":"#DIV/0!"}},{"$f":"$B$81*C98/C95*2","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Ω"]
[{"$f":"VLOOKUP(\"R_eq_Ring\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"R_eq_Ring"},{"$f":"B96/2","v":{"$error":"#DIV/0!"}},{"$f":"C96/2","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"I96/2","v":{"$error":"#DIV/0!"}},{"$f":"J96/2","v":{"$error":"#DIV/0!"}},{"$f":"K96/2","v":{"$error":"#DIV/0!"}},"Ω"]
[{"$f":"VLOOKUP(\"L_max\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"L_max"},{"$f":"IF((((($B$86-((SUM($C$21,$C$23,$C$25,$C$27)*0.1)*$B$85))/$B$85)*B$95)/$B$81)>3500,3500,(((($B$86-((SUM($C$21,$C$23,$C$25,$C$27)*0.1)*$B$85))/$B$85)*B$95)/$B$81))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"m"]
[]
[{"$f":"VLOOKUP(\"Cálculo Corriente Máxima\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Maximum current calculation"}]
[{"$f":"VLOOKUP(\"Sección de cable\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Cable cross section"},{"$f":"$B$10","v":0},"mm2",null,null,null,null,null,{"$f":"IF(B101<0.5,\"Error: La sección mínima de cable en el lazo es 0,5 mm2\",\"\")","v":"Error: La sección mínima de cable en el lazo es 0,5 mm2"}]
[{"$f":"VLOOKUP(\"Longitud efectiva de cable\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Effective cable length"},{"$f":"IF(B14=Data!D46,$B$11-MIN(B12,B13),$B$11)","v":0},"m",{"$f":"B12/B11","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(B13/B11,\"\")","v":""},{"$f":"(B11-B12-B13)/B11","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(B11>3500,VLOOKUP(\"Error: La longitud máxima de lazo es 3500 m\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\"\")","v":""}]
[{"$f":"VLOOKUP(\"R_Cable_Sis\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"R_Cable_Sys"},{"$f":"IFERROR(((($B$81*B102)/B101)*2)+(SUM(C21,C23,C25,C27,)*0.1),\"\")","v":""},"Ω"]
[{"$f":"VLOOKUP(\"R_eq_Clase\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"R_eq_Class"},{"$f":"IFERROR(B103*C14,\"\")","v":""},"Ω","Depende de la topología del lazo",{"$f":"VLOOKUP(\"Depende de la topología de lazo\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Depends on the loop topology"}]
[{"$f":"VLOOKUP(\"R_eq_Final\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"R_eq_Final"},{"$f":"IFERROR((((($B$81*B11*F102)/B101)*2)+(SUM(C21,C23,C25,C27,)*0.1))*C14*C15+IF(B14=Data!D46,((($B$81*B11*(MAX(D102,E102))/B101)*2)*C14),((($B$81*B11*D102)/B101)*2)*C14+((($B$81*B11*E102)/B101)*2)*C14),\"\")","v":""},"Ω","Depende del factor de distribución",{"$f":"VLOOKUP(\"Depende del factor de distribución\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Depends on the distribution factor"}]
[{"$f":"VLOOKUP(\"Caída de tensión\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Voltage drop"},{"$f":"IFERROR(B85*B105,\"\")","v":""},"V"]
[{"$f":"VLOOKUP(\"Corriente máxima\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Maximum current"},{"$f":"IFERROR($B$86/$B$105-$R$9*10^-3,\"\")","v":""},"A"]
["I_max"]
[{"$f":"VLOOKUP(\"Comprobación sistema\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"System check"}]
[{"$f":"VLOOKUP(\"Corriente\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Consumption"},null,{"$f":"IFERROR(IF($B$85>0.75,VLOOKUP(\"FALLO\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),IF($B$107>=$B$85,\"OK\",\"FALLO\")),VLOOKUP(\"ERROR\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE))","v":"OK"},null,null,null,null,null,{"$f":"IFERROR(IF($B$85>0.75,VLOOKUP(\"Error: La corriente de lazo es mayor que la corriente máxima permitida\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),IF($B$107<$B$85,VLOOKUP(\"Error: La corriente de lazo es mayor que la corriente máxima permitida\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\"\")),VLOOKUP(\"ERROR: Los datos no son correctos\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE))","v":""}]
[{"$f":"VLOOKUP(\"Direcciones\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Directions"},null,{"$f":"IF($N$77<=250,VLOOKUP(\"OK\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),VLOOKUP(\"FALLO\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE))","v":"OK"},null,null,null,null,null,{"$f":"IF($N$77>250,VLOOKUP(\"Error: El lazo no admite más de 250 direcciones\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE),\"\")","v":""}]
[]
[]
[{"$f":"VLOOKUP(\"Esta herramienta se puede utilizar como ayuda de diseño para Detnov Security S.L.\",Translations!A4:E209,MATCH('System Calculation'!J7,Translations!A1:E1,0),FALSE)","v":"This tool may be used as a design help for Detnov Security S.L. We reserve the right not to be responsible for its accuracy, completeness or quality of the information provided, including any kind of information which could be incomplete or incorrect."}]

{"sheet":"External power supply","index":3,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,9,50,22],[6,3,6,6],[8,1,13,1],[1,1,1,7],[3,1,4,2],[3,3,4,7],[28,2,29,7],[28,1,29,1],[16,2,18,7],[16,1,18,1],[25,2,26,7],[25,1,26,1],[20,2,23,7],[20,1,23,1]]}
[]
[null,{"$f":"VLOOKUP(\"Fuente de alimentación externa\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"External power supply"},null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[]
[null,{"$f":"VLOOKUP(\"Modo de uso\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Use mode"},null,{"$f":"VLOOKUP(\"Elegir fuente de alimentación según la capacidad de batería total requerida para la autonomía del sistema\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Choose the power supply depending on the total required battery capacity for the system autonomy"}]
[]
[]
[null,null,null,{"$f":"VLOOKUP(\"Fuentes de alimentación\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Power Supply Units"},null,null,null,{"$f":"VLOOKUP(\"Accesorio\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Accesory"}]
[null,null,null,"TUL500 EN","STX2405-E","STX2410-E","STX2410-H","BATT-BOX-65-BLACK"]
[null,{"$f":"VLOOKUP(\"Baterías\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Batteries"},"BTD-1207"]
[null,null,"BTD-1212"]
[null,null,"BTD-1218"]
[null,null,"BTD-1224"]
[null,null,"BTD-1244"]
[null,null,"BTD-12120"]
[]
[]
[null,{"$f":"VLOOKUP(\"Nota 1\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Note 1"},{"$f":"VLOOKUP(\"En verde están indicadas\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"In green are indicated the batteries that can be used in each power supply, and in red the ones that do not fit in their box. The accesory box BATT-BOX-65-BLACK can be used with all the power supplies and allows up to 65 Ah batteries."}]
[]
[]
[]
[null,{"$f":"VLOOKUP(\"Nota 2\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Note 2"},{"$f":"VLOOKUP(\"La fuente de alimentación TUL500\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"The TUL500 EN power supply differences from the others are:\n- It has a total of 3 outputs, whereas the others have only 1 output, so both outputs could be connected to the FAD-AUXBAT card.\n- It only works with european mains, and not with the american one as the others do."}]
[]
[]
[]
[]
[null,{"$f":"VLOOKUP(\"Nota 3\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Note 3"},{"$f":"VLOOKUP(\"El dibujo muestra\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"The drawing shows the common way of connecting 2 power supplies. For other combinations check the installation manuals of the FAD-AUXBAT card."}]
[]
[]
[null,{"$f":"VLOOKUP(\"Nota 4\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Note 4"},{"$f":"VLOOKUP(\"Aunque la fuente de alimentación\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Although the STX2402-E power supply is also in the catalog, it is not appropiate for the system as it delivers less current than the internal power supply of the panel."}]

{"sheet":"Data","index":4,"n_rows":50,"n_cols":28,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
[]
["Características centrales",null,null,null,null,null,null,"Características baterías"]
["Central",null,"I_Reposo (A)","I_Alarma (A)","Imax (A)","Capacidad BAT max",null,null,"Voltaje (V)","Capacidad (Ah)",null,null,null,"TABLA AUXILIAR"]
["CAD-151-1 & CAD-150-1-Mini",{"$f":"N6","v":"CAD_151_1"},0.115,0.17899999999999999,2.6,12,null,"BTD-1207",12,7.2,120,"BTD-12120",null,"Centrales"]
["CAD-151-2",{"$f":"N7","v":"CAD_151_2"},0.14299999999999999,0.17899999999999999,2.6,12,null,"BTD-1212",12,12,44,"BTD-1244",null,null,{"$f":"N6","v":"CAD_151_1"},{"$f":"N7","v":"CAD_151_2"},{"$f":"N8","v":0},{"$f":"N9","v":0},{"$f":"N10","v":0},{"$f":"N11","v":0},{"$f":"N12","v":0},{"$f":"N13","v":0},{"$f":"N14","v":0},{"$f":"N15","v":0},{"$f":"N16","v":0},{"$f":"N17","v":0},{"$f":"N18","v":0},{"$f":"N19","v":0}]
[null,null,null,null,null,null,null,"BTD-1218",12,18,24,"BTD-1224",null,"CAD_151_1","BTD-1207","BTD-1207"]
[null,null,null,null,null,null,null,"BTD-1224",12,24,18,"BTD-1218",null,"CAD_151_2","BTD-1212","BTD-1212"]
[null,null,null,null,null,null,null,"BTD-1244",12,44,12,"BTD-1212"]
[null,null,null,null,null,null,null,"BTD-12120",12,120,7.2,"BTD-1207"]
[]
[null,null,null,null,null,null,null,"Características baterías"]
[null,null,null,null,null,null,null,"Cantidad tarjetas"]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,1]
[]
[null,null,null,null,null,null,null,"Sección cable","AWG"]
[null,null,null,null,null,null,null,0.5,21]
[null,null,null,null,null,null,null,0.8,20]
[null,null,"Tiempos según normativa",null,null,null,null,1,18]
[null,null,"Reposo (h)","Alarma (min)",null,null,null,1.5,16]
[null,null,72,30,null,null,null,2,15,null,null,null,null,"TABLA AUXILIAR 2: para condición de batería necesaria"]
[null,null,48,15,null,null,null,2.5,14]
[null,null,30,5,null,null,null,4,12,null,null,null,null,"Centrales"]
[null,null,24,0,null,null,null,null,null,null,null,null,null,"CAD_151_1","BTD-1207","BTD-1212"]
[null,null,4,60,null,null,null,null,null,null,null,null,null,"CAD_151_2","BTD-1207","BTD-1212"]
[null,null,null,null,null,null,null,"Fuentes alimentación:"]
[null,null,null,null,null,null,null,120,"STX2410 + BATT-BOX-65"]
[null,null,null,null,null,null,null,38,"STX2410-H"]
[null,null,null,null,null,null,null,17,{"$f":"VLOOKUP(\"TUL500 EN o STX24XX-E\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"TUL500 EN or STX24XX-E"}]
[]
[null,null,null,null,null,null,null,{"$f":"'System Calculation'!A15","v":0},{"$f":"VLOOKUP(H31,Data!B4:D17,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(H31,Data!B4:D17,3,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"'System Calculation'!A16","v":0},{"$f":"VLOOKUP(H32,Data!H4:J7,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(H32,Data!H4:J7,3,0)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,"Minimum battery needed",null,"Dif. Entre BTD y Minimum battery needed"]
[null,null,null,null,null,null,null,{"$f":"'System Calculation'!E23","v":{"$error":"#N/A"}},{"$f":"MATCH(J35,K4:K9,-1)","v":{"$error":"#N/A"}},{"$f":"H35-J32","v":{"$error":"#N/A"}},{"$f":"MATCH(J35,H27:H29,-1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"BAT necesaria",{"$f":"INDEX(L4:L9,I35,1)","v":{"$error":"#N/A"}},"PS necesaria:",{"$f":"INDEX(I27:I29,K35,1)","v":{"$error":"#N/A"}}]
[]
[]
[]
["Para ocultar valores en celda: formato de numero. En el cuadro tipo escribir ;;; (3 puntos y coma)"]
[]
[]
["Factor de distribución",null,null,"Topología"]
["Distribución","Factor",null,"Clase","Factor"]
[1,0.56999999999999995,null,{"$f":"VLOOKUP(\"Clase A\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Class A"},0.27,"Se divide entre 2 tanto la resistencia como la corriente, factor 4, corregido según pruebas con MAD-565-I"]
[0.75,{"$f":"B49-(A46*(B49-B45))","v":0.67749999999999999},null,{"$f":"VLOOKUP(\"Modo degradado\",Translations!$A$4:$E$209,MATCH('System Calculation'!$J$7,Translations!$A$1:$E$1,0),FALSE)","v":"Degraded mode"},1.18]
[0.5,{"$f":"B49-(A47*(B49-B45))","v":0.78499999999999992}]
[0.25,{"$f":"B49-(A48*(B49-B45))","v":0.89249999999999996}]
[0,1]
[null,"* Estos valores han sido diseñados respecto al producto de más consumo: MAD-565-I"]

{"sheet":"Translations","index":5,"n_rows":209,"n_cols":4,"rows_kept":209,"cut":false,"hidden":false,"merged":[]}
["Texto","Español","English","Your language"]
["Idioma","Idioma","Language"]
["Pulsar botón para reiniciar todos los valores e iniciar un nuevo proyecto","Pulsar botón para reiniciar todos los valores e iniciar un nuevo proyecto","Press the button to reset all the values and start a new project"]
["Tiempo respaldo baterías","Tiempo respaldo baterías","Battery backup time"]
["Tiempo en reposo","Tiempo en reposo","Standby time"]
["Tiempo en alarma","Tiempo en alarma","Alarm time"]
["Nota: los valores seleccionados no cumplen EN 54","Nota: los valores seleccionados no cumplen EN 54","Note: the values selected do not comply with EN 54"]
["Parámetros del sistema y baterías","Parámetros del sistema y baterías","Battery and system parameters"]
["Salida auxiliar 24 V central","Salida auxiliar 24 V central","Panel auxilliary 24 V output"]
["Salida sirenas 1","Salida sirenas 1","Sounder output 1"]
["Salida sirenas 2","Salida sirenas 2","Sounder output 2"]
["I_Total_Reposo","I_Total_Reposo","I_Total_Standby"]
["I_Total_Alarma","I_Total_Alarma","I_Total_Alarm"]
["Factor de degradación","Factor de degradación","Derating factor"]
["Batería seleccionada para la autonomía","Batería seleccionada para la autonomía","Battery selected for backup time"]
["Consumo sistema","Consumo sistema","System consumption"]
["Batería mínima necesaria","Batería mínima necesaria","Minimum battery required"]
["Máximo nº sirenas en alarma simultánea","Máximo nº sirenas en alarma simultánea","Maximum sounders in alarm at the same time"]
["Tiempo baterías*","Tiempo baterías*","Battery time*"]
["*Tiempo baterías = Tiempo reposo + Tiempo en alarma","*Tiempo baterías = Tiempo reposo + Tiempo en alarma","*Battery time = Standby time + Alarm mode time"]
["Seleccionar tiempo en reposo","Seleccionar tiempo en reposo","Select standby time"]
["Seleccionar tiempo en alarma","Seleccionar tiempo en alarma","Select alarm time"]
["Seleccionar central de la lista","Seleccionar central de la lista","Select control panel from the list"]
["Seleccionar batería de la lista","Seleccionar batería de la lista","Select battery from the list"]
["Sirenas","Sirenas","Sounders"]
["Cumplimentar el campo para el máximo % de sirenas en alarma al mismo tiempo (campo amarillo)","Cumplimentar el campo para el máximo % de sirenas en alarma al mismo tiempo","Fill the field for the maximum % of sounders in alarm at the same time"]
["Nota: los valores seleccionados no cumplen EN 54","Nota: los valores seleccionados no cumplen EN 54","Note: this value does not comply with EN 54"]
["Aviso: Corriente máxima 500 mA excedida. Necesaria fuente externa 24V","Aviso: Corriente máxima 500 mA excedida. Necesaria fuente externa 24 V","Warning: 500 mA maximum current exceeded. External 24 V needed"]
["No suficiente","No suficiente","Not enough"]
["Necesita fuente de alimentación externa:","Necesita fuente de alimentación externa:","External power supply needed:"]
["Con baterías adicionales mínimas de:","Con baterías adicionales mínimas de:","With minimum additional batteries:"]
["El sistema excede el consumo máximo permitido","El sistema excede el consumo máximo permitido","The system exceeds the maximum consumption allowed "]
["Revisar pestaña Conexión fuente externa","Revisar pestaña External power supply","Check External power supply tab"]
["Lazo","Lazo","Loop"]
["Lazo 1","Lazo 1","Loop 1"]
["Lazo 2","Lazo 2","Loop 2"]
["Total","Total","Total"]
["I_Reposo (A)","I_Reposo (A)","I_Standby (A)"]
["I_Alarma (A)","I_Alarma (A)","I_Alarm (A)"]
["Tarjetas auxiliares","Tarjetas auxiliares","Extension cards"]
["PCS","PCS","PCS"]
["Cumplimentar el campo PCS si la central tiene tarjetas auxiliares (campo amarillo)","Cumplimentar el campo PCS si la central tiene tarjetas auxiliares","Fill the PCS field if the panel includes extension cards"]
["Esta herramienta se puede utilizar como ayuda de diseño para Detnov Security S.L.","Esta herramienta se puede utilizar como ayuda de diseño para Detnov Security S.L. Nos reservamos el derecho de no ser responsables de la exactitud, integridad o calidad de la información proporcionada, incluido cualquier tipo de información que pueda ser incompleta o incorrecta.","This tool may be used as a design help for Detnov Security S.L. We reserve the right not to be responsible for its accuracy, completeness or quality of the information provided, including any kind of information which could be incomplete or incorrect."]
["Sección de cable","Sección de cable","Cable cross section"]
["Longitud de lazo","Longitud de lazo","Loop length"]
["Distancia de S al primer dispositivo","Distancia de S al primer dispositivo","Distance from S to first device"]
["Distancia de R al último dispositivo","Distancia de R al último dispositivo","Distance from R to last device"]
["Topología de lazo","Topología de lazo","Loop topology"]
["Factor de distribución","Factor de distribución","Distribution factor"]
["Clase A","Clase A","Class A"]
["Modo degradado","Modo degradado","Degraded mode"]
["Información","Información","Information"]
["Esta es la distancia de la salida del lazo hasta el primer dispositivo","Esta es la distancia de la salida del lazo hasta el primer dispositivo","This is the distance from the S of the loop to the first device"]
["Esta es la distancia del último dispositivo al retorno del lazo","Esta es la distancia del último dispositivo al retorno del lazo","This is the distance from the last device to the R of the loop"]
["La topología de lazo hace referencia","La topología de lazo hace referencia a si el lazo está cerrado en Clase A, o si el lazo está en modo degradado porque sufre alguna avería de lazo abierto","Loop topology takes into account whether the loop is closed in Class A, or the loop is in degraded mode due to an open loop fault "]
["El factor de distribución hace referencia","El factor de distribución es una estimación de cómo de equitativo están distribuidos los dispositivos en el lazo, siendo el 100% distribuidos perfectamente","Distribution factor is an estimation of how equitative are the devices distributed along the loop, being 100% perfectly distributed"]
["TUL500 EN o STX24XX-E","TUL500 EN o STX24XX-E","TUL500 EN or STX24XX-E"]
["metros","metros","meters"]
["Comprobación sistema","Comprobación sistema","System check"]
["Corriente","Corriente","Consumption"]
["Direcciones","Direcciones","Directions"]
["FALLO","FALLO","FAIL"]
["ERROR","ERROR","ERROR"]
["OK","OK","OK"]
["Trama comunicaciones","Trama comunicaciones","Communication frame"]
["Error: La longitud máxima de lazo es 3500 m","Error: La longitud máxima de lazo es 3500 m","Error: The loop maximum length is 3500 m"]
["La suma de distancias desde la central a los dipositivos no puede ser mayor a la longitud de lazo","La suma de distancias desde la central a los dipositivos no puede ser mayor a la longitud de lazo","The sum of both distances from the panel to the devices can not be greater than the loop length"]
["Lazo abierto. Toda la corriente en el mismo extremo del cable (peor caso)","Lazo abierto. Toda la corriente en el mismo extremo del cable (peor caso)","Open loop. All the current through the same cable end (worst case)"]
["Lazo cerrado. Se divide la corriente por los dos extremos (mejor caso)","Lazo cerrado. Se divide la corriente por los dos extremos (mejor caso)","Closed loop. The current is divided on both ends (best case)"]
["Todos en el mismo extremo del cable (peor caso)","Todos en el mismo extremo del cable (peor caso)","All the elements in the same end (worst case)"]
["Distribuidos equitativamente (mejor caso)","Distribuidos equitativamente (mejor caso)","Equally distributed (best case)"]
["Caso intermedio","Caso intermedio","Intermediate case"]
["Cumplimentar Sección de cable en mm2 y Longitud de lazo en metros (campo amarillo)","Cumplimentar Sección de cable en mm2 y Longitud de lazo en metros","Fill Cable cross section in mm2 and Loop length in meters"]
["Seleccionar el factor de distribución en el lazo y topología de clase","Seleccionar el factor de distribución en el lazo y topología de clase","Select the distribution factor in the loop and the topology"]
["Cumplimentar el campo PCS para la configuración deseada (campo amarillo)","Cumplimentar el campo PCS para la configuración deseada ","Fill the PCS field for the desired configuration"]
["Dispositivos Lazo 1","Dispositivos Lazo 1","Loop 1 devices"]
["Dispositivos Lazo 2","Dispositivos Lazo 2","Loop 2 devices"]
["REF.","REF.","REF."]
["Descripción","Descripción","Description"]
["PCS","PCS","PCS"]
["I_Sirenas (A)","I_Sirenas (A)","I_Sounders (A)"]
["DET","DET","DET"]
["MOD","MOD","MOD"]
["SIR","SIR","SND"]
["DIR","DIR","DIR"]
["Info: El máximo número de barreras es 20","Info: El máximo número de barreras es 20","Info: The maximum number of beam detectors is 20"]
["Info: Alinear barreras de una en una","Info: Alinear barreras de una en una","Info: Align beam detectors one by one"]
["Info: Fuente externa 24V necesaria. La central puede dar 24Vaux, si la corriente máxima 500mA no es excedida.","Info: Fuente externa 24V necesaria. La central puede dar 24Vaux, si la corriente máxima 500mA no es excedida","Info: External 24V power supply needed. The panel can provide 24V aux, if the maximum 500 mA current is not exceeded"]
["Info: Fuente externa 24V necesaria. Certificada EN 54-4","Info: Fuente externa 24V necesaria. Certificada EN 54-4","Info: External 24V power supply needed. Certified by EN 54-4"]
["Parámetros de lazo","Parámetros de lazo","Loop parameters"]
["I_Reposo","I_Reposo","I_Standby"]
["I_Alarma","I_Alarma","I_Alarm"]
["I_Sirenas","I_Sirenas","I_Sounders"]
["I_Total","I_Total","I_Total"]
["V_Lin_Anillo","V_Lin_Anillo","V_Lin_Ring"]
["Sección mínima de cable para longitudes estándar","Sección mínima de cable para longitudes estándar","Minimum cable cross section for standard lenghts"]
["Longitudes","Longitudes","Lengths"]
["R_Cable","R_Cable","R_Cable"]
["R_eq_Anillo","R_eq_Anillo","R_eq_Ring"]
["S_min","S_min","S_min"]
["Longitud máxima de cable para secciones estándar (IEC 60228)","Longitud máxima de cable para secciones estándar (IEC 60228)","Maximum cable length for standard cross sections (IEC 60228)"]
["Sección","Sección","Cross section"]
["R_Cable","R_Cable","R_Cable"]
["R_eq_Ring","R_eq_Anillo","R_eq_Ring"]
["L_max","L_max","L_max"]
["Aviso: La sección mínima de cable en el lazo es 0,5 mm2","Aviso: La sección mínima de cable en el lazo es 0,5 mm2","Warning: The minimum cross section in the loop is 0,5 mm2"]
["Cálculo Corriente Máxima","Cálculo corriente máxima","Maximum current calculation"]
["Longitud efectiva de cable","Longitud efectiva de cable","Effective cable length"]
["R_Cable_Sis","R_Cable_Sis","R_Cable_Sys"]
["R_eq_Clase","R_eq_Clase","R_eq_Class"]
["R_eq_Final","R_eq_Final","R_eq_Final"]
["Caída de tensión","Caída de tensión","Voltage drop"]
["Corriente máxima","Corriente máxima","Maximum current"]
["Depende de la topología de lazo","Depende de la topología de lazo","Depends on the loop topology"]
["Depende del factor de distribución","Depende del factor de distribución","Depends on the distribution factor"]
["Error: La corriente de lazo es mayor que la corriente máxima permitida","Error: La corriente de lazo es mayor que la corriente máxima permitida","Error: The loop current is greater than the maximum current allowed"]
["Error: El lazo no admite más de 250 direcciones","Error: El lazo no admite más de 250 direcciones","Error: The loop does not allow more than 250 directions"]
["Indicaciones","Indicaciones","Indications"]
["Reduzca el número de direcciones utilizadas","Reduzca el número de direcciones utilizadas","Reduce the number of used directions"]
["Trate de reducir el consumo ajustando la cantidad de dispositivos","Trate de reducir el consumo ajustando la cantidad de dispositivos","Try to reduce the consumption adjusting the number of devices"]
["Trate de modificar los parámetros de cable y lazo","Trate de modificar los parámetros de cable y lazo","Try to modify the cable and loop parameters"]
["ERROR: Los datos no son correctos","ERROR: Los datos no son correctos","ERROR: The data introduced is not correct"]
["Revise o rellene los datos de configuración de lazo","Revise o rellene los datos de configuración de lazo","Check or fill the loop configuration data"]
["Fuente de alimentación externa","Fuente de alimentación externa","External power supply"]
["Modo de uso","Modo de uso","Use mode"]
["Elegir fuente de alimentación según la capacidad de batería total requerida para la autonomía del sistema","Elegir fuente de alimentación según la capacidad de batería total requerida para la autonomía del sistema","Choose the power supply depending on the total required battery capacity for the system autonomy"]
["Baterías","Baterías","Batteries"]
["Fuentes de alimentación","Fuentes de alimentación","Power Supply Units"]
["Accesorio","Accesorio","Accesory"]
["Nota 1","Nota 1","Note 1"]
["En verde están indicadas","En verde están indicadas las baterías que pueden ponerse en cada una de las fuentes de alimentación, y en rojo las que no caben en la caja. Con la caja accesorio BATT-BOX-65-BLACK se podría usar cualquier fuente de alimentación con baterías hasta 65 Ah.","In green are indicated the batteries that can be used in each power supply, and in red the ones that do not fit in their box. The accesory box BATT-BOX-65-BLACK can be used with all the power supplies and allows up to 65 Ah batteries."]
["Nota 2","Nota 2","Note 2"]
["La fuente de alimentación TUL500","La fuente de alimentación TUL500 EN se diferencia del resto en dos factores:\n- Tiene un total de 3 salidas, a diferencia de las otras que solo tienen 1 salida, por lo que se podrían usar 2 salidas de la TUL500 EN para conectarlas a la tarjeta FAD-AUXBAT.\n- Solo funciona con tensión de red europea, y no americana como incluyen las otras.","The TUL500 EN power supply differences from the others are:\n- It has a total of 3 outputs, whereas the others have only 1 output, so both outputs could be connected to the FAD-AUXBAT card.\n- It only works with european mains, and not with the american one as the others do."]
["Nota 3","Nota 3","Note 3"]
["El dibujo muestra","El dibujo muestra la forma común de conectar 2 fuentes externas. Para otras combinaciones consultar los manuales de instalación de la tarjeta FAD-AUXBAT.","The drawing shows the common way of connecting 2 power supplies. For other combinations check the installation manuals of the FAD-AUXBAT card."]
["Nota 4","Nota 4","Note 4"]
["Aunque la fuente de alimentación","Aunque la fuente de alimentación STX2402-E también esté en catálogo, no es adecuada para el sistema puesto que proporciona menos corriente que la fuente interna de la central.","Although the STX2402-E power supply is also in the catalog, it is not appropiate for the system as it delivers less current than the internal power supply of the panel."]
["Detector óptico analógico","Detector óptico analógico","Addressable optical smoke detector"]
["Detector óptico analógico con aislador incorporado","Detector óptico analógico con aislador incorporado","Addressable optical smoke detector with built-in isolator"]
["Detector óptico-térmico","Detector óptico-térmico","Addressable optical & heat detector"]
["Detector óptico-térmico con aislador incorporado","Detector óptico-térmico con aislador incorporado","Addressable optical & heat detector with built-in isolator"]
["Detector térmico analógico","Detector térmico analógico","Addressable heat detector"]
["Detector térmico analógico con aislador incorporado","Detector térmico analógico con aislador incorporado","Addressable heat detector with built-in isolator"]
["Detector térmico de alta temperatura analógico","Detector térmico de alta temperatura analógico","Addressable high temperature detector"]
["Detector térmico de alta temperatura analógico con aislador incorporado","Detector térmico de alta temperatura analógico con aislador incorporado","Addressable high temperature detector with built-in isolator"]
["Detector autónomo de gas natural (24V)","Detector autónomo de gas natural (24V)","Standalone natural gas detector (24V)"]
["Detector autónomo de gas natural (230V)","Detector autónomo de gas natural (230V)","Standalone natural gas detector (230V)"]
["Detector autónomo de GLP (24V)","Detector autónomo de GLP (24V)","Standalone LPG detector (24V)"]
["Detector autónomo de GLP (230V)","Detector autónomo de GLP (230V)","Standalone LPG detector (230V)"]
["Detector lineal de humos analógico","Detector lineal de humos analógico","Addressable beam smoke detector"]
["Módulo analógico de 1 entrada (sin/con aislador)","Módulo analógico de 1 entrada (sin/con aislador)","Addressable module 1 input (with/without isolator)"]
["Módulo analógico de 2 entradas (sin/con aislador)","Módulo analógico de 2 entradas (sin/con aislador)","Addressable module 2 inputs (with/without isolator)"]
["Módulo analógico de 5 entradas con aislador","Módulo analógico de 5 entradas con aislador","Addressable module 5 inputs with isolator"]
["Módulo analógico de 10 entradas con aislador","Módulo analógico de 10 entradas con aislador","Addressable module 10 inputs with isolator"]
["Módulo analógico de 1 salida (sin/con aislador)","Módulo analógico de 1 salida (sin/con aislador)","Addressable module 1 output (with/without isolator)"]
["Módulo analógico de 2 salidas (sin/con aislador)","Módulo analógico de 2 salidas (sin/con aislador)","Addressable module 2 outputs (with/without isolator)"]
["Módulo analógico de 5 salidas con aislador","Módulo analógico de 5 salidas con aislador","Addressable module 5 outputs with isolator"]
["Módulo analógico de 10 salidas con aislador","Módulo analógico de 10 salidas con aislador","Addressable module 10 outputs with isolator"]
["Módulo analógico de 1 entrada/1 salida (sin/con aislador)","Módulo analógico de 1 entrada/1 salida (sin/con aislador)","Addressable module 1 input/1 output (with/without isolator)"]
["Módulo analógico de 2 entradas/2 salidas (sin/con aislador)","Módulo analógico de 2 entradas/2 salidas (sin/con aislador)","Addressable module 2 inputs/2 outputs (with/without isolator)"]
["Módulo analógico de 5 entradas/5 salidas con aislador","Módulo analógico de 5 entradas/5 salidas con aislador","Addressable module 5 inputs/5 outputs with isolator"]
["Módulo analógico de 10 entradas/10 salidas con aislador","Módulo analógico de 10 entradas/10 salidas con aislador","Addressable module 10 inputs/10 outputs with isolator"]
["Módulo analógico de 1 salida 24V (sin/con aislador)","Módulo analógico de 1 salida 24V (sin/con aislador)","Addressable module 1 24V output (with/without isolator)"]
["Módulo analógico de 2 salidas 24V (sin/con aislador)","Módulo analógico de 2 salidas 24V (sin/con aislador)","Addressable module 2 24V outputs (with/without isolator)"]
["Módulo analógico de 1 zona convencional (sin/con aislador)","Módulo analógico de 1 zona convencional (sin/con aislador)","Addressable module 1 conventional zone (with/without isolator)"]
["Módulo analógico de 2 zonas convencionales (sin/con aislador)","Módulo analógico de 2 zonas convencionales (sin/con aislador)","Addressable module 2 conventional zones (with/without isolator)"]
["Módulo analógico de 1 salida 230V","Módulo analógico de 1 salida 230V","Addressable module 1 230V output"]
["Módulo analógico de 1 salida 230V con aislador","Módulo analógico de 1 salida 230V con aislador","Addressable module 1 230V output with isolator"]
["Módulo analógico aislador","Módulo analógico aislador","Addressable module isolator"]
["Pulsador analógico con aislador","Pulsador analógico con aislador","Addressable manual call with isolator"]
["Sirena analógica con aislador","Sirena analógica con aislador","Addressable sounder with isolator"]
["Sirena analógica con flash y aislador","Sirena analógica con flash y aislador","Addressable sounder with beacon and isolator"]
["Sirena analógica con VAD y aislador","Sirena analógica con VAD y aislador","Addressable sounder with VAD and isolator"]
["VAD analógico con aislador","VAD analógico con aislador","Addressable VAD with isolator"]
["Base sirena con aislador","Base sirena con aislador","Sounder base with isolator"]
["Base sirena y VAD con aislador","Base sirena y VAD con aislador","Sounder base and VAD with isolator"]
["Base VAD con aislador","Base VAD con aislador","VAD base with isolator"]
["Base sirena","Base sirena","Sounder base"]
["Base sirena y flash","Base sirena y flash","Sounder base with beacon"]
["Piloto indicador analógico con aislador","Piloto indicador analógico con aislador","Addressable remote indicator with isolator"]
["Conexión central convencional 2 zonas","Conexión central convencional 2 zonas","Conventional control panel conection 2 zones"]
["Conexión central convencional 4 zonas","Conexión central convencional 4 zonas","Conventional control panel conection 4 zones"]
["Conexión central convencional 8 zonas","Conexión central convencional 8 zonas","Conventional control panel conection 8 zones"]
["Conexión central convencional 12 zonas","Conexión central convencional 12 zonas","Conventional control panel conection 12 zones"]
["Conexión central de extinción","Conexión central de extinción","Extinguising control panel conection"]
["MAD-464-I Vol. Bajo (78 dB)","MAD-464-I Vol. Bajo (78 dB)","MAD-464-I Low Vol. (78 dB)"]
["MAD-464-I Vol. Medio (93 dB)","MAD-464-I Vol. Medio (93 dB)","MAD-464-I Medium Vol. (93 dB)"]
["MAD-464-I Vol. Alto (97 dB)","MAD-464-I Vol. Alto (97 dB)","MAD-464-I High Vol. (97 dB)"]
["MAD-465-I Vol. Bajo (78 dB)","MAD-465-I Vol. Bajo (78 dB)","MAD-465-I Low Vol. (78 dB)"]
["MAD-465-I Vol. Medio (93 dB)","MAD-465-I Vol. Medio (93 dB)","MAD-465-I Medium Vol. (93 dB)"]
["MAD-465-I Vol. Alto (97 dB)","MAD-465-I Vol. Alto (97 dB)","MAD-465-I High Vol. (97 dB)"]
["MAD-564-I (lazo)","MAD-564-I (lazo)","MAD-564-I (loop)"]
["MAD-564-I (FA externa)","MAD-564-I (FA externa)","MAD-564-I (external PS)"]
["MAD-565-I (lazo)","MAD-565-I (lazo)","MAD-565-I (loop)"]
["MAD-565-I (FA externa)","MAD-565-I (FA externa)","MAD-565-I (external PS)"]
["MAD-565-I - solo flash (lazo)","MAD-565-I - solo flash (lazo)","MAD-565-I - only flash (loop)"]
["MAD-565-I - solo flash (FA externa)","MAD-565-I - solo flash (FA externa)","MAD-565-I - only flash (external PS)"]
["MAD-567-I (lazo)","MAD-567-I (lazo)","MAD-567-I (loop)"]
["MAD-567-I (FA externa)","MAD-567-I (FA externa)","MAD-567-I (external PS)"]
["MAD-569-I (lazo)","MAD-569-I (lazo)","MAD-569-I (loop)"]
["MAD-569-I (FA externa)","MAD-569-I (FA externa)","MAD-569-I (external PS)"]
["MAD-569-I - solo flash (lazo)","MAD-569-I - solo flash (lazo)","MAD-569-I - only flash (loop)"]
["MAD-569-I solo flash (FA externa)","MAD-569-I solo flash (FA externa)","MAD-569-I only flash (external PS)"]
["TPLD-100 (CCD-102) = 3 dir. Lazo","TPLD-100 (CCD-102) = 3 dir. Lazo","TPLD-100 (CCD-102) = 3 Loop dir."]
["TPLD-100 (CCD-104) = 5 dir. Lazo","TPLD-100 (CCD-104) = 5 dir. Lazo","TPLD-100 (CCD-104) = 5 Loop dir."]
["TPLD-100 (CCD-108) = 9 dir. Lazo","TPLD-100 (CCD-108) = 9 dir. Lazo","TPLD-100 (CCD-108) = 9 Loop dir."]
["TPLD-100 (CCD-112) = 13 dir. Lazo","TPLD-100 (CCD-112) = 13 dir. Lazo","TPLD-100 (CCD-112) = 13 Loop dir."]
["TPLD-100 (CCD-103) = 7 dir. Lazo","TPLD-100 (CCD-103) = 7 dir. Lazo","TPLD-100 (CCD-103) = 7 Loop dir."]
["No poner nada después de esta linea","Ir añadiendo filas encima","Add rows above this one"]